Navigation:  NexusDB Guide > Management Tools > The Enterprise Manager > Browsing Tables and Queries >

Browsing a Table

Previous pageReturn to chapter overviewNext page

NexusDB V3 Manual

Browsing a Table

button_main button_prev button_next

NexusDB Manual V3 > Management Tools > The Enterprise Manager > Browsing Tables and Queries

 

When you want to view or edit the data in your tables, or check results of filters, ranges etc, the Table Browser window will do this and more.

 

The first thing to not is that the table browser is a dock able window and can be floated if you like. By default the window is docked to the full client area of the main window and each open table will be tabbed on the bottom.

 

clip0178

 

Data Grid

 

For finding out about how to manage the data in the data grid please refer to the Data Grid section.

 

Indices

 

By selecting and Index from the list, you define which Index is used for the viewing order and to which index a range is applied to. To use the Find Nearest and Set Range functions, which both require a searchable index, select an index other than the Sequential Access Index.

 

Find Nearest

 

This option is only visible if you have an Index different from the Sequential Access Index selected. Enter the value you want to look for, press the Find button and the data grid will be positioned on the first record matching the value.

 

The search is performed by looking up the data in the index and thus it will only find index keys matching the value.

 

Ranges

 

Ranges allow you to very quickly restrict the data grid view to a subset of records only by specifying a lower and upper indexed value.

 

Use the Set Range/Clear Range value to enable a Range and Edit Range to change a previously set range.

 

The Set Range dialog that is popped up, is dynamically configured to have one line of settings for each field in an index. Set start and end values for each field to be ranged, and press OK. The fields and options correspond to the SetRange() and KeyExcusive parameters that you would use in normal table-handling code.

 

clip0179

 

Please note: You need to have an Index different from the Sequential Access Index selected to use ranges.

 

Filters

 

The Filter edit allows the dataset to be filtered on any field regardless of any indexes existing. Be warned that filtering is slow on large tables; ranges should be used to reduce the records that needs to be filtered if possible.

 

The filter syntax is the same as Delphi's TDataset; see the TDataset.Filter property help topic in the Delphi help files for more info on the syntax.

 

If the Sql Filter checkbox is turned on, then the filter syntax is instead expected to be as if it was a SQL WHERE statement (without the WHERE keyword). For instance, the SQL keyword LIKE could be used, example filter:  Artist LIKE '%Sa%'  which would return any artist where the name included "Sa" somewhere.

 

BLOB Fields

 

If the table contains Blob fields, then the bottom area of the window will display the blobs in the active record (see picture above, the Blob field contains an image). This can be turned off in the View menu for browsing speed.

 

New Menus

 

When made the active window, the Table Browser window adds a few menus to the main menu. These are discussed in the next section.

© Nexus Database Systems Pty Ltd.

nexus_logo