Online Documentation for SQL Query for InterBase/FireBird

Grid


Colors

Options of this group allow you to set colors for basic grid elements. Use the ellipsis EllipsisButton button to open the Color dialog allowing you to select the required color from the palette.

 

Grid

Defines the background color of the data grid.

 

Row

Defines the color of the selected row in the data grid.

 

Stripy

Defines the color of the odd rows (applied if the Stripy grids option is set).

 

 

Display formats

Integer fields

Defines the format for displaying SMALLINT, INTEGER and BIGINT fields.

 

Float fields

Defines the format for displaying FLOAT, DOUBLE and DECIMAL fields.

 

DateTime fields

Defines the format for displaying DATETIME fields.

 

Date fields

Defines the format for displaying DATE fields.

 

Time fields

Defines the format for displaying TIME and TIMESTAMP fields.

 

hs4117 - Environment Options - Grid

 

 

NULL values

Text

Defines the text that stands for NULL values in grid.

 

Font color

Defines the font color for displaying NULL values in the grid. Use the ellipsis EllipsisButton button to open the Color dialog allowing you to select the required color from the palette.

 

 

Options

CheckBox Stripy grids

Displays the odd grid rows in the colors specified by the Stripy option.

 

CheckBox Use Ctrl+Up to increase spin values

Allows you to use the Ctrl+Up and the Ctrl+Down key combinations for editing the spin values (numeric field values).

 

CheckBox Show editor immediately

Checking this option allows you to edit the cell value immediately after you click the cell.

 

CheckBox Enable auto-search in grid

If this option is checked, the cursor is automatically forwarded to the closest match when you start typing.

 

CheckBox Row multi-selection

With this option set, multiple rows can be selected in grid.

 

CheckBox Load all rows mode

With this option off, the grid loads only a fixed number of data records into the memory. This option minimizes dataset loading time. Automatic sorting, filtering, summary calculations are not supported in this mode.

With this option on, the grid loads all records from the returned dataset. This option increases the grid performance by reloading only the modified data records during the update process. In this mode all features (automatic sorting, filtering and summary calculations) are available.

 

CheckBox Query fetch all records

With this option set, all records are fetched upon a query execution.

 

CheckBox Show text fields as string

If this option is checked, the text fields are viewed as ordinary strings. Otherwise they are displayed as BLOB fields.

 

Max fields width (chars)

Defines the maximum width of CHAR and VARCHAR fields displayed in the grid.

 

Min fields width (chars)

Defines the minimum width of CHAR and VARCHAR fields displayed in the grid.

 

 

Grid layout preferences

RadioButton Save and restore layout

Select the option to keep the original grid width.

 

RadioButton Autofit column width
Select option to shrink the grid columns so that the longest visible value fits the column width.