Code Table Field Definitions

Visual LANSA Framework

Code Table Field Definitions

This contains the field definitions for the code table. When editing field data, there will be a column for every field defined in this grid.

Each entry in this grid can have the following options:

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

 

Move Up

The button changes the sequence of a field definition.

The relative displayed sequence determines the key sequence for key fields

 

Move Down

The button changes the sequence of a field definition.

The relative displayed sequence determines the key sequence for key fields

 

Delete

The button deletes a field definition from this Table

 

This property is in the Code Table Definition tab.