NexusDB V3 Manual

Using SQL

This is where SQL queries can be tested and executed. For a full reference of SQL:2003 and the various NexusDB SQL extensions please take a look at the according SQL Reference Book of this manual.

The SQL script input area accepts scripts of any length. Multi-statement scripts must have each single statement terminated with ';'. If the statement is a single SELECT statement, or the last statement in a multi-statement query is a SELECT, then the query result set displays in the grid after execution.

Data Grid

To find out more about the possibilities the data grid provides please check out the chapter Customizing the Data Grid.

Query Window

If the last statement is not a SELECT, the grid will be empty and instead the status bar will display how many records were affected by the last non-SELECT statement. If live (editable) queries is turned on in the local and global options, and the query syntax conforms to what is supported for live queries, the grid will be editable, otherwise it will be read-only. If you want to change values in a non-live query, either use UPDATE statements, or open the table in a table browser window.

The query browser window allows you to have several SELECT statements open on the same database at once. This is a handy way to compare different variants of a query to see which records they return. Use the Create New Connection function to add statements. The list of statements is displayed in the combo box in the toolbar.

The Log/Execution Plan Window

To view NexusDB's SQL execution plan for a query, a log window can be activated. Note that in order to return the necessary log, the query must include the #L+ option. It is auto inserted at the top of the query text when you turn on the log via the menu.

Blob Fields

If the query result set contains Blob fields, then the bottom area of the window will display the blobs in the active record. This can be turned off in the View menu for browsing speed.

New Menus

The following menus are added to the main menu when a SQL Browser window is active: the Query menu, the Query View menu, the Query Connections menu and the Query Options menu. We now a closer look at each of them.