Code Table Field Definitions

Field Name

The choice for this value depends on the kind of Table Data Handler you are using.

For Tables with data sourced from user defined files it is convenient to give the Table field the same name as the file field. For Tables with data sourced from the generic storage file it does not matter as long as the name is unique within this table and is non-blank.

Key

This specifies this field as an identifying key field for the table.

Its key number (e.g. whether its AKey1 or AKey2) is determined by its sequence in the grid, relative to the other key fields.

There can be up to 5 keys, and they can be either Numeric or Alphanumeric. The key fields must be chosen so that they uniquely identify a table data row.

Alphanumeric keys can be up to 32 characters long.

Numeric keys must fit within a 15,5 decimal field.

Caption

The field caption is used to identify the field when editing data or selecting a field.

Type:

The field type - Alpha or numeric

Max Length

The maximum length a value for this field can be.

Note: Alpha key fields should never be more than 32 characters. Numeric key fields should fit within a field of 15, 5

Decimals

The number of decimal places for numeric fields.

Upper Case Only

Values in this field should always be upper case