| |
Home |
![[Table of Contents]](/dwicons/b_toc.gif)
|
SQL Advantage User's Guide |
![[-]](/dwicons/i_colpse.gif)
| Chapter 1: Introduction |
|
| SQL Advantage Result Windows |
Result windows open following the successful execution of a query. Result window contents are displayed as text or in a spreadsheet-like grid according to preferences that you set (see "Setting Result Preferences"). The default result window display is single text.
You can edit results data using standard Windows editing functions such as cut, copy, and paste.
Note: You can edit only the results data, not the actual data in the database. You cannot update the database by editing the results.
Result windows have a control menu, and Minimize and Maximize controls that are similar to the corresponding session window controls (see "Session Window Control Menu", "Session Window Minimize Control", and "Session Window Maximize Control").
According to preferences that you set, when you choose to display results in text output mode, you can also choose to create a single text result window for all query batches, or create multiple windows with a separate result window for each batch (see "Setting Result Preferences").
The contents of a single text result window are overwritten by the results of subsequent executions of query scripts in the associated query window. When you select multiple text result windows, the results for each query appear in a separate result window.
When you display results in multiple text result windows (see Figure 1-5), a result window opens for each query within the script, displayed in a cascaded fashion.
Each multiple result window comprises two panes. The upper query window pane displays the corresponding T-SQL query within the script, and the lower result window pane contains the results of the execution of that query.
The query script in the result window query pane cannot be selected for execution; however, you can select the text, copy it to the session window query pane, and execute it from there.
Figure 1-5: Multiple text result window
When you choose to display results in single text result windows (see Figure 1-6), a single result window displays all the results after you execute a query that returns one or more sets of results, regardless of the size of the script. In a single text result window, results are displayed with the same output format as that used by Sybase ISQL.
Each single text result window has only one window pane that displays all the results from your query. There is no result window message pane as in multiple text result windows.
Figure 1-6: Single text result window
When results are displayed in grid output mode, a separate grid result window opens for each query within the script, just as with multiple text result windows.
A grid result window is created for every query execution (see Figure 1-7). The upper, query window pane contains the corresponding T-SQL query within the script, and the lower, result window pane contains the result of that query execution.
Text up to the length specified by the text display length option in the Result Preferences dialog box can be displayed. Maximum text buffer size is specified by the Text/Image Size preference (see "Setting Result Preferences").
If you click a cell and then choose Edit Cell... from the View menu, or double-click a cell, the Edit Cell dialog box opens (see Figure 2-27) which, in the case of text or image data type, displays all text up to the size of the Text/Image Size buffer. For other cells, the entire contents are displayed. You can perform standard editing functions on the results text in the cell using this dialog box. The edited cell content does not alter data in the database, that is you cannot update the database by editing the results.
Figure 1-7: Grid result window
|
|