Setting grid and data options
The Grid and Data options 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.
Set required fields in grid
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, you calculated field values can't 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. The according 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 can't edit this record. This helps to avoid conflicts of collective access to the database.
Data Options
Use separate connections for each data view within a database
Check this option to enable creation of the separated connection for each data view. Using it is not recommended if maximum allowed number of connections is too low.
Asynchronous query execution
Check this option to allow executing queries in background mode (asynchronously).
Perform data sorting on client in data view
If the option is unchecked, the data will be sorted according to SQL sorting parameters.
Perform data filtration on client in data view
Check/uncheck this option to enable/disable client filter in data view of Table Editor and View Editor.
With the the option enabled the sorting is performed by means of the grid when clicking the column header.
If the option disabled all table data will be reloaded with the selected field in ORDER BY expression of the SELECT statement (the query will be executed on server side).
Sort by primary key
When enabled, the option allows sort data by the primary key on opening the Data Grid.
String fields width (chars)
Using this option you can limit string fields width that may improve performance on large datasets.
Default Grid Mode defines grid mode which will be used by default.
With the Load all rows option enabled, when loading data, all the records are loaded into grid buffers. In this mode opening the tables with many records may take a very long time. But in this case you have some advantages: e.g. in the filter drop-down list the column headers are displayed with the values for quick filter; it is possible to open several sublevels at the same time when viewing data in master-detail view, etc.
Because opening and other operations with an object consisting of many records takes sufficient time the Load visible rows mode should be used instead. It can be set individually for each table and is saved between sessions (can be set via grid context menu).
- Load all rows
The grid loads all records from a dataset. This option increases the grid performance by reloading only changed dataset records when updating. In this mode all features (automatic sorting, filtering and summary calculations) are available.
- Load visible rows
The grid loads only a fixed number of dataset records into memory. This option minimizes dataset loading time. The automatic sorting, filtering, summary calculations are not supported in this mode.
Load visible rows mode if records more than...
Set this option to switch to the Load visible rows mode when the number of records in the dataset exceeds the specified value.
|
See also: |
