NexusDB V3 Manual

Global Options

There are some global options that can be set in the EM.  These options are available via "Global Options" from the main menu when you first boot-up as shown in the figure below.

Most of these options are also accessible through and their current state visible in the global options toolbar. The icons in the toolbar are the same as the ones used in the menu.

Readonly Datasets

This option toggles Read-only mode for all SQL and table browser windows.

NOTE: To protect against inadvertently modifying data, by default (when the EM is first used) this option is on.  If you want to modify data whilst in the EM, then you will need to set this option off.

Optimistic Locks

Determines whether table browser windows use optimistic or pessimistic locking when performing edits. Affects tables opened after the setting has been changed.

RecNo Support

RecNo support is a special feature to accommodate correct positioning with the thumbs slider on grids. This option needs extra calculations and work on the server side and thus can have a huge impact on the performance. Use it carefully if necessary, and especially avoid it's use on large tables.

Default Timeout

The default timeout value is set to 10 seconds as shown in the screen shot below.  This value is used as the default when table browsers are opened and for SQL queries.

Note that the value 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 the value used will be the value of the next highest level component in the connection chain to the currently selected server.  For the internal server, that is also 10 seconds.  For external servers the value may be different.

Heartbeat Frequency (ms)

How often EM sends heartbeat messages to the connected server(s) to inform them that its still alive. If the connection is lost for the duration of 2 heartbeats, the server closes the connection and frees up server-side resources.

Display Milliseconds

Whether time/datetime fields displays the millisecond part of the time values.

Use Unicode Grid

If you need to view or edit unicode data, turn this option on. It will force the use of a less pretty, but unicode compliant grid in the table and query browser windows.

Runtime Loaded Packages

This new feature of EM enables you to load and unload extension packages for EM. An extension package can add new menu items and data descriptor definitions/editor functionality to EM and is mainly targeted at third-party developers to directly integrate into EM.

Pressing the Add button opens a file selector which prompts the user to select a package that he wants to load into EM. The Remove button unloads the selected package. If you press Cancel the dialog will be closed without actually performing the loading/unloading of packages, OK commits the changes and adds/removes the packages chosen.

Visual Style

This option is purely for the user interface. It has no impact on the functionality or performs any functionality on data. You can select between OS Default (default style used by the operating system), Standard (the normal Windows 2000 and lower look), .NET (the new .NET tools look), XP (Windows XP look) and Office 11 (the look of MS Office 11/2003).