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