DATA-TYPES (alphanumeric)

Describes various entry characteristics of each column. Each time you set this property, you describe the data type for the next column in the grid, starting with the first. Setting this property to spaces clears the previously specified data types.

A data type specification contains two components. The first is a single character that describes the set of legal characters that the user may type in this column. The set of possible values is:

Character Description Characters Allowed
X Alphanumeric All characters
U Uppercase alphanumeric All characters — automatically converted to uppercase
L Lowercase alphanumeric All characters — automatically converted to lowercase
9 Number Digits, local decimal point, sign, space
Z Edited number Digits, sign, period, comma, local currency symbol, $, *, /, %, space
I Integer Digits, sign, space
P Positive integer Digits, space
D Date Digits, /, hyphen
E European Date Digits, /, hyphen, period

You may specify the data type character in either upper or lower case. After the data type character, you may specify the maximum number of characters that may be entered in this column. This value is specified in parentheses. Two values have special meanings:

When a cell may contain more text than it can display, the cell scrolls horizontally in a fashion similar to entry fields.

You may omit either part of the specification. If the data type part is omitted, it defaults to X (all characters allowed). If the size is omitted, it defaults to 0 (match the size of the column). These defaults also apply to columns for which DATA-TYPES has not been specified.

For example, to specify that a column should allow 30 uppercase characters, specify U(30). To create a column that allows only digits for the width of the column, use P(0), or just P.

Note: The data type character limits only which characters the user can enter into the column. The grid itself does not further validate or format the entered data. To do so, you should respond to the MSG-FINISH-ENTRY event. The grid's character filtering is intended only to provide the first stage of validation by allowing only characters that are appropriate for certain types of data.