Columns dialog

Text

Display string values (that is, alphanumeric text).

Numeric

Display numeric values.

Picture

Display the specified image file (.bmp or .ico) located in the Web sub-folder of your project folder. For example, if the value from the data source is MyFile.bmp, the Grid object will display the image file located at <project name>/Web/MyFile.bmp.

If it is a .bmp file, the image may be resized or stretched to fit the column. If it is an .ico file, which can contain several scaled versions of the same image, the version that best fits the column will be automatically selected and then resized if necessary. In both cases, resized images cannot be aligned in the column (that is, the Align setting for the column will have no effect).

If the specified image file cannot be found during project run time, a default image is displayed instead. To change the default image, manually edit your project file (<project name>.APP) to change the following property:

[Objects]

GridDefaultPicture=<file name>

Note: Projects running on Windows Embedded support .bmp files but not .ico files.

Check-box

Display the values, typically Boolean, as check boxes. While a value is TRUE (that is, non-zero), the check box is selected. While a value is FALSE (that is, zero) or NULL, the check box is cleared.

If the Input option is selected for the column, and the user selects or clears the check box during project run time, the value is set to 1 or 0, respectively. This is true even if the value is not Boolean. Therefore, it is possible for a large numeric value (for example, 1000) or even a string value to be reset to 1 when the check box is cleared and then selected again.

Time

Display the values in the time format (for example, HH:MM:SS).

This type is available only when the Grid object's data source is set to Database, because each value is assumed to be a database timestamp that can be parsed to get the actual time.

Date

Display the values in the date format (for example, MM/DD/YYYY).

This type is available only when the Grid object's data source is set to Database, because each value is assumed to be a database timestamp that can be parsed to get the actual date.

Date/Time

Display the values in the date/time format (for example, MM/DD/YYYY HH:MM:SS).

This type is available only when the Grid object's data source is set to Database, because each value is assumed to be a database timestamp that can be parsed to get the actual date and time.

Time – UTC

Display the values in the time format (for example, HH:MM:SS).

This type is available only when the Grid object's data source is set to Database, because each value is assumed to be a database timestamp that can be parsed to get the actual time. Also, the timestamp is assumed to be in Coordinated Universal Time (UTC), and it is automatically converted to the local time zone in the project viewer / thin client.

Date – UTC

Display the values in the date format (for example, MM/DD/YYYY).

This type is available only when the Grid object's data source is set to Database, because each value is assumed to be a database timestamp that can be parsed to get the actual date. Also, the timestamp is assumed to be in Coordinated Universal Time (UTC), and it is automatically converted to the local time zone in the project viewer / thin client.

Date/Time – UTC

Display the values in the date/time format (for example, MM/DD/YYYY HH:MM:SS).

This type is available only when the Grid object's data source is set to Database, because each value is assumed to be a database timestamp that can be parsed to get the actual date and time. Also, the timestamp is assumed to be in Coordinated Universal Time (UTC), and it is automatically converted to the local time zone in the project viewer / thin client.