NexusDB Manual V3 > Management Tools > The Enterprise Manager > Browsing Tables and Queries > Using SQL
|
The Query Options menu lets the user switch live datasets on and set query specific options.
As with most other menus, there's a corresponding toolbar:
Request Live Dataset (Ctrl+D)
Determines whether the next SELECT statement attempts to return a live (editable) dataset. NOTE: Turning it on does not guarantee that the result set is editable.
Properties (Ctrl+P)
Opens the query property dialog.
The Query property dialog has 2 tabs.
In the first tab Active Query you can change the request live dataset and timeout settings for the next execution of the query statement. Note that the value for timeout is presented in milliseconds (there are 1,000 milliseconds per second). If you set this value to 0 milliseconds, then the timeout is ignored (has, to all intent purposes, an infinite value). This can be handy when you are testing a particularly complex query which may take many minutes to evaluate however, generally speaking, you would want the timeout to be a finite value to guard against deadlock situations.
If you set this value to -1, then typically the value of the Global Options will be used.
You can also switch syntax highlighting on and off (this affects all open windows).
In the second tab Global Defaults
you can set the timeout, live dataset and Font used for all subsequently opened queries. |
© Nexus Database Systems Pty Ltd.