Online Documentation for SQL Manager for InterBase/Firebird

Grid

The Grid section of the Database Registration Info dialog allows you to adjust the default grid mode settings.

Enable boolean fields support

If this option is checked, boolean fields are supported in data grid.

Set required fields in grids

If this option is checked, you have to set values for all the NOT NULL table fields.

Set calculated fields as read-only

If this option is checked, calculated field values cannot be edited.

Get default values for fields

If this option is checked, SQL Manager will automatically get the default field values from the database server.

Get record count beforehand

If this option is checked, SQL Manager automatically calculates the number of records in table or query. Corresponding information is displayed in the status bar.

Trim Char Fields in Grids

If this option is checked, the final spaces in fields of the CHAR type are trimmed during the editing process.

Auto Commit Transactions

If this option is checked, SQL Manager automatically commits transactions, otherwise you have to do it manually.

Protected edit (block record while editing)

If this option is checked, SQL Manager blocks the record you are editing, so that other users cannot edit this record. This helps to avoid conflicts of collective access to the database.