Record Menu Help

The Record menu allows you to modify records in the Data Editor.

This menu is enabled only if a Data Editor is active.

Creates a new record and move the cursor into the first field of that new record so you can start type.

Creates a new record in the related Table and move the cursor into the first field of that new record so you can start type.

Opens a Confirm dialog to confirm if you want to delete all records from the table.

Immediately deletes selected records.

Opens a Confirm dialog to confirm the removal of all rows from a table, but leave the table structure, columns, constraints, indexes, and the rest unchanged.

Marks all records in the table.

Unmarks all records in the table.

Displays all records in the table.

Displays only the marked records in the table.

Hides all marked records in the table.

This submenu contains commands to work with filters on records.

Adds one more FILTER row (green color) on the top of Table Editor. You can add few FILTER rows. If exists at least one FILTER row then WHERE row becomes disabled.

Adds a single WHERE row on the top of Table Editor. If exists WHERE row then FILTER row becomes disabled.

Removes the FILTER/WHERE row. This forces also all records to be shown.

Removes the last filter added without applying other changes to filters.

Applies conditions of the filter to select and show subset of records in the Table.

Transforms the filters into SQL and opens the result in the SQL Editor.

Display and define special data objects. This allows you to define some additional view options for the Data Editor. The following options may be switched on or off. This sub-menu is available only for Valentina Database format databases and displays properties only available in that format.

Shows the RecID of each record as the first column of grid.

Shows the OID of each record the first or the second column of grid.

Shows calculated fields of the table.

READ MORE ...