Record Menu

This menu shows which database/row-oriented actions are available when you have a table opened and the focus of the Database Explorer is in the data view on the Data tab page.

Some options—such as delete and save—become available based on the current status. When the table is opened in read-only mode, you will never be able to select the delete option. When there is nothing to save or when the table is read-only, you cannot use the save option.

Add/Remove Row

This function—only available in the grid view mode—adds a new blank row to the data grid on the Data tab page so that you can enter a new record.

Clear

This function clears the current row buffer. In the grid view mode, an undo will be performed on the changes made to the current row. In the single record view mode, the forms will be cleared.

Find By RowId

This option opens a dialog that allows you to enter a RowId and find a row containing that RowId.

Find First

This function will find the first row in the table. When filters are active, the first row in the table based on the active filter will be found.

Previous Record

This function will find the previous row in the table. When filters are active, the previous row in the table based on the active filter will be found.

Find GE

This function finds a record based on the entered key values. In an existing record, you can change the value and choose this menu option. If a record exists with the value, it will be displayed instead of the current record. The rest of the data display will be adjusted to show the place of the newly found record amongst the others.

Next Record

This function will find the next record in the table. When filters are active, the next row in the table based on the active filter will be found.

Find Last

This function will find the last record in the table. When filters are active, the last row in the table based on the active filter will be found.

Refresh Data

This function refreshes the data view. It is very possible that while the Database Explorer was active, some other task or user changed data. This button refreshes the data displayed, keeping the current record—when possible—active. Alternatively, you can tell Database Explorer to perform an auto-refresh.

Delete

This function attempts to delete the currently active record. The option is not available when the table is opened in read-only mode or when there is no record in memory to delete.

Save

This function is active when you have changed the current active record or when you are creating a new record. When active and selected, the system is instructed to save the record.

Manage Filters

This function opens a submenu in which you can edit, delete, add, store, and load filters. Read more about this at using filters.

Apply Filters

This function scans all defined filters of the currently opened table and sets their status to active or inactive. The data view tries to find a row that matches the filter. This might result in no rows found.

Filter by Value

This function takes the value of the currently selected row and column in the data view and creates an EQ filter (constraint) on this value. All other active filters will be made inactive. They remain present but will be deactivated until you activate them again.

Replace Column Values

This option brings you to a dialog in which you can instruct Database Explorer to change the value of a given column to a different value.