NexusDB V3 Manual

The Query Menu

The Query menu is only visible if a query window is active. It's main purpose is to let the user load, save and execute SQL queries.

Alternatively you can also use the

Query toolbars.

Execute (Ctrl+E or F9)

Opens or runs an SQL statement. If the statement contains parameters, a dialog will pop up to get parameter values before execution starts.

Open (Ctrl+O)

Read in SQL scripts stored on disk.

Save (Ctrl+S)

Save SQL scripts to disk.

Show Previous Statement (Alt+Left)

Brings back the query statement that was previously executed. Every time the query text is changed and then executed, the query text is saved in a list that can be browsed back and forth to easily compare statements.

Show Next Statement (Alt+Right)

Brings back the next query statement in the saved list of statements.

Find (Ctrl+F)

Search for a particular word in the current SQL script.

Parameter values (Ctrl+M)

Open the parameter values dialog manually.

Enter the values in the Param Value column; if you want the parameter to be NULL leave it blank. Select the correct type in the ParamType dropdown list (accepts keyboard input). Press Enter or click OK to run the statement with these paramenters.

Copy To Table

Copy the active result set to a new table.

Click New Table if you want to create a new empty table. Check Copy Blobs to copy blobs.

Print Preview (Ctrl+R)

Opens the current active result set in the Report Engine print preview. See section Printing Reports chapter for more information.

Design Report (Ctrl+T)

Opens the Report Engine design view. See section Printing Reports chapter for more information.