Database Toolbar

The band contains a toolbar with fourteen buttons.

Find First Record

Finds the first record in the table. If filters are active, it will be the first record according to the filter settings.

Find Previous Record

Finds the previous record in the table. If filters are active, it will be the previous record according to the filter settings.

Find Greater or Equal to

Performs a find based on the entered key values. If filters are active, it will be the last record according to the filter settings.

Find Next Record

Finds the next record in the table. If filters are active, it will be the next record according to the filter settings.

Find Last Record

Finds the last record in the table. If filters are active, it will be the last record according to the filter settings.

Clear

Clears the record buffer for the current record. Made changes will be undone. In single record view mode, the input controls will be cleared as well. In grid mode, the row will be cleared if you were entering a new record, and it will restore the previous values from the record when you were making changes.

Save

Saves the current record. Only active when changes were made and the table is not opened in read-only mode.

Delete

Deletes the current record.

Delete All

This button is available on opened tables that are not opened in read-only mode and when the "erase all data" (zerofile) configuration option is enabled. The delete all button does not perform a zerofile but deletes all records one-by-one that can be found in the table. Since finding records can be limited by the configuration of a filter, you can use this to quickly delete all records that match given criteria, such as all customers in a state or with no activity in the last couple of years.

Refresh Data

This button will refresh the data in the data view now. Made changes will be lost.

Open As

This button pops up the Open As dialog. In this dialog, you can enter the name of a table or select one from the Windows common file dialog. If you click OK, Database Explorer attempts to open the table.

Open Table

This button opens the currently pointed table in the tree view. If the tree view node is not a table, the button is disabled. This is a useful function when you do not want to use the tree interval timer and have navigated with the cursor keys to the current table entry. This function is also available from the floating menu in the tree view for table entries.

Sort Order Buttons

When the cursor is in an indexed column, two extra buttons appear. The selected button shows the current sort order (ascending/descending). Clicking the other button will toggle the sort direction of the data grid. This feature is only active when using the data grid.