Grid

Colors

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 if the Stripy Grids option is on.

Null Values

Text
Defines the text that stands for the NULL value.

Font Color
Defines the font color displaying NULL values in the grid.

Display Formats

Integer Fields
Defines the format for displaying TINYINT, SMALLINT, MEDIUMINT, 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 fields.

String Fields Width
Defines the width of CHAR and VARCHAR fields displayed in the grid.

Currency Fields
Defines the format for displaying MONEY fields

Limit

   Select all records
Selects all the records from the table, no matter how many records there are in the table.

Records
This option is available only if Select all records is off. It defines the maximum number of records, selected from the table at a time.

Other Options

   Stripy Grids
Displays the odd grid rows in a different color, defined by the Stripy option.

   Autofit Columns
This option is available only if Save Grid View is off. It shrinks the grid columns so that the longest visible column value fits.

   Save Grid View
This option is available only if Autofit Columns is off. It saves the original grid width.

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

   Show editor immediately
Allows editing the cell value right after the cell is clicked.

Advanced

Data retrieving method
Defines if a complete data set is retrieved at a time or the data set is retrieved row-by-row.

See also:

Data Frame