Query Editor Output Pane


The query editor's output pane is a tabbed interface displaying SQL execution messages (information, warnings, errors etc.) and result sets.

Query Execution Output

When executing any type of query, the connection in use and SQL text is logged to the pane. Success and error messages will be displayed following the executed SQL text for any particular query.

The pane may be cleared of its content at any time using the Clear output log button on the editor's toolbar.

The generated editor output may be logged to file. This may be configured from the user application preferences.

Result Set Output

Results sets generated from executed queries are displayed as separate tabs within the output pane. Multiple result set generating queries are displayed in their own tabs in the order of execution.

Open result set displays from previously executed queries are reset upon execution of a new 'query set' unless the next query was executed as a single statement at the cursor position (see executing SQL queries). In this case, a new tab is appended to the end of the display.

Result set tabs allow for display and navigation to the originating query by placing the mouse cursor over any particular tab. Executed queries may be scrolled, copied or referenced back to the editor from the popup window on roll-over.

Selecting a result set's column header will sort the returned records in ascending or descending order and back again on the specific column selected. Column reordering is also supported and may be achieved by dragging any column from its header to a new position in the table display.