This form has three variants depending which button on the Data Dictionary Editor form you select to launch it:
The Add Field form is displayed when you select the Add Field button ![]()
The Amend Field form is displayed when you select the Amend Field button ![]()
The Delete Field form is displayed when you select the Delete Field button ![]()
Details:
Name: The data dictionary being created, amended, or deleted
Description: Typically the purpose or owner of the dictionary
Link status: Use the drop-down menu to select from:
- Not linked
- Import link (read-only)
- Export link (read/write)
Link Properties:
Note: This group box is greyed out if Link status is set to Not linked.
Module: Use the drop-down menu to select the Autoline module associated with the data dictionary field
Table: Use the drop-down menu to select the data table associated with the data dictionary field
Column: Column of the data table, specified in the Table field, associated with the data dictionary field
Tip: Use the ellipsis button
to search for a column, and the drop-down button
to select a value for the second sub-field.
Field Properties:
Note: This group box is greyed out if Link status is set to Import link or Export link.
Type: The kind of data stored in the field:
- A: Character (text)
- B: Boolean (Yes or No)
- D: Date
- T: Time
- N: Number
Size: The number of bytes allocated to the field, which for text fields is the maximum number of characters that it can contain
Validation: The type of check carried out on data entered into the field, for example R for Range
Note: Size and Validation are greyed-out if these values are implicitly defined by the field's Type, for example Boolean fields can only contain Y for Yes or N for No.
Range: Maximum and minimum limiting values for the field's data, for example 1 - 100
Note: Range is blank or ignored unless Validation is set to R for Range.
Default value: Data automatically inserted into the field upon creation of a record of this type
Automatic Validation:
Type: Use the drop-down menu to select automatic validation appropriate to the field type from:
None: No validation is performed on the field's data, and no error message is displayed if it is left blank
Mandatory field: The field must contain data
Advisable field: The field should contain data but can exceptionally be left blank
Validate only: The field's data is validated according to the type of validation held in Validation
PUSH BUTTONS:
Note: Only one button is displayed, Add, Amend, or Delete, depending on whether the form is the Add Field form, Amend Field form, or Delete Field form.
Add: Inserts a new field into the data dictionary, after which the Add Field form closes, returning you to the Data Dictionary Editor form, which displays the new field as a line in its grid
Amend: Updates the data dictionary field, after which the Amend Field form closes, returning you to the Data Dictionary Editor form, which displays the updated field in its grid
Delete: Removes the data dictionary field