Validation

Check Box Data

If Control Type is CheckBox, this specifies how checked and unchecked values are written to the data file, in the format "checked;unchecked". Typical values might be "Y;N" or "1;0".

Table Based

Validate Data Table

To validate a code against a lookup table, enter the table name here.

Data Column

Select the data element from the validation table to be displayed as a description to the right of the entered code.

Data Key

If the lookup key is a complex expression, enter it here. The expression can include any combination of BBj string functions, string literals, and [stbl] references, with @ acting as a place holder for the data value itself. For example:

[+FIRM_ID]+"C"+@

Data Key Name

If the validation key is not the primary key, select the secondary key here.

Additional

Minimum Length

To enforce a minimum length, enter it here.

Maximum Length

To enforce a maximum length, enter it here.

Maximum Rows

To enforce a maximum number of rows, enter it here. This value is only meaningful for CustomEdit (BBjCEdit) GUI controls.

Minimum Value

To enforce a minimum value, enter it here.

Maximum Value

To enforce a maximum value, enter it here.

Data Expand Code

If a transformation must be applied to the data when reading it from the file, select an expansion code here. The expression is defined in the Expansion Codes maintenance program; % is the place holder for the raw value read from the file:

Data Compress Code

If a transformation must be applied to the data when writing it to the file, select a compression code here. The expression is defined in the Compression Codes maintenance program; % is the place holder for the value as entered by the user:

Justification

Select one of:

• None (default – don't justify/pad data)

• Left (Justify left – text style)

• Right (Justify right – numeric style)

Pad Character

Select from the list:

• None (default)

• Space ( )

• Quote (")

• Pound (#)

• Asterisk (*)

• Period (.)

• Zero (0)

• Caret (^)

• Underscore (_)

Precision

For NumericEdit (BBjInputN) fields, specify the decimal precision in the range -1..99.

System Dialog

To override the default Find lookup function and map it to a File Open or File Save dialog, select a system dialog here. The choices are:

• None (default)

• File Open

• File Save