Status Bar

The status bar is divided into four panes with a value. The fifth and last pane fills up the status bar.

ReadOnly / Read Write Icon

This pane shows whether the rows of the table are currently editable or not. If dbAdminMode is set to Database Mode or Full Mode, or when the configuration option to allow toggle is turned ON, you can click on the icon to change the current mode. The toggle between read-only and read/write is not stored for the next open operation while the configuration option “open tables read only” is active for all tables.

Status Text

This pane shows the status in which Database Explorer currently is. While building the data view, several messages like "building DDO’s" are shown. When navigating through the edit controls (grid or single record view mode), the pane shows table and column information such as the name of the table and column, type of the column, and size of the column.

Run As Administrator

When Database Explorer is started via "Run As Administrator", this is shown in a pane with the text "Administrator". When it is executed without this, the pane is hidden.

Constraint Counters

This pane shows the values for CONSTRAIN_FOUND_COUNT and CONSTRAIN_TESTS_COUNT. These are two global integers that are incremented while finding records with a filter active. Clicking on the pane resets the counters to zero.

FileList

This pane shows the name of the filelist that is currently in use. If the path to the filelist is too long to fit in the pane, a part of the path will be shown with dots indicating the truncation.

RowId

This pane shows the serialized form of the current RowId. Clicking on the RowId pane value brings up the search by rowid dialog (also available using Ctrl+F in the data grid).

Grid Sort Direction

Clicking the header item in a grid column changes the current sort order of the grid to the main index of the column (if any). If you click a second time, the sort direction changes from ascending to descending. This status bar pane shows the sort direction.

Limited Number of Columns

By default, the configuration is set to not load more than the first 20 columns of your table. If the number of columns exceeds the limit set in the grid, this pane shows an icon to inform you about the status.

Sort Indication

An icon here shows the sort order currently active in the data grid. When ASCENDING, the "AZ" with a down arrow icon is displayed; when DESCENDING, the "AZ" with an up arrow icon is displayed. Users can change the sort direction by clicking on the column header in the data grid if the column is indexed.

CAP

This pane shows the status of the CapsLock key. When not enabled, the color is light gray.

NUM

This pane shows the status of the NumLock key. When not enabled, the color is light gray.

SCRL

This pane shows the status of the ScrollLock key. When not enabled, the color is light gray.