(Contents)(Previous)(Next)

Edit Dictionary Field Form

This form has three variants depending which button on the Data Dictionary Editor form you select to launch it:

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:

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 DropDown.gif 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:

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:

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


(Contents)(Previous)(Next)(Top of the Page)