Home > Teratrax Source Guard > Help > SQL Query User Interface

SQL Query User Interface

The SQL Query window of Teratrax Source Guard is composed of multiple panes. The Editor pane is a text editor where you can enter SQL statements. The Results pane displays the returned recordset. The Errors pane displays error messages. If the SQL batches in the Editor pane return more than one recordset, a list of all returned recordsets will be made visible in the Recordsets pane. The Recordsets pane will not be displayed if your SQL batches return a single recordset. The moving Splitter separates the Editor pane from the rest of the panes. Click on a pane to make it the active pane. Alternatively, press F6 to move between panes.

The Results pane displays the columns and rows from a table or query in a grid. You can modify the data in the grid. You can also insert and delete rows. If more than one recordset is returned, some of the recordsets may be returned as "Read Only" for performance purposes. The Recordsets pane will display the status of all recordsets as either "Read Only" or "Live". Usually the first recordset in the batch is live. 

Editor Pane

You can execute a complete script or only selected SQL statements in the SQL Query window. To execute a complete script, create or open the script in the Editor pane and press F5. To execute only selected SQL statements, highlight the lines of code in the Editor pane and press F5. Click on Working with Queries (Grid) for more information on the Results pane.

Status Bar Information

The SQL Query window provides information about activity and connections in its status bar. The status bar is composed of the following boxes (from left to right):

1. Status of the current operation, including number of successful and unsuccessful batch.
2. Duration of last query.
3. Current user and server process identifier (ID).
4. Name of the current database server with version information, number of CPUs, and available memory.
5. Insert/Overwrite mode setting: displays "OVR" for overwrite mode and INS for insert mode.
6. CAPS lock setting: displays "CAP" when on.

Results Pane

The Results pane consists of the data grid. The number of rows returned is displayed on the pane's caption. The current position of the insert cursor in the window is shown in the current grid cell. On the left side, the grid has a marker that marks the position of the current row. Click on Working with Results (Grid) for more information on the Results pane.

Keyboard Shortcuts

You can select any menu option in the SQL Query window by simply holding the Alt key and pressing the appropriate menu shortcut (for example, Alt+F for the File menu). Additionally, you can access some of the most common features directly through keyboard shortcuts. This table displays all the keyboard shortcuts available in the SQL Query window: