Record validation

The record validation feature allows a PFT file to be defined which will be used on demand to verify data entry accuracy for each field, for a new record as well as for an existing one.

In order to achieve this, a form containing all fields defined in the FDT file will be displayed along with a text box to specify the validation format to be applied individually to each field. Next to this a checkbox is also displayed ( ) which subjects record saving to a validation result: when a record is being entered or modified and the checkbox is ticked, it will not be saved if any of the checked fields do not meet the validation criteria.

When entering data, and using all this information, ABCD builds up a format where partial validations are consolidated. This format is applied to the record and displays messages in the form of inconditional literals, which will notify the operator about validation results.

When the validation form is built, the following options are displayed at the end of the page:

Apply to Mfn : applies the validation format on the requested MFN and shows the result. Enter the MFN of the requested record and click on Apply.

Update: this stores the developed validation format in the subfolder def of the corresponding database. This file is stored under the database name, with the extension .val, and it has the following format: (example):

20:if a(v20) then `field 20 is missing` fi
510:"Field 510 is missing "n510
900:if a(v900) then `field 900 is missing` fi

The field number is placed in front of the validation format to make it easier to carry out any modification, if required. The format will prompt a literal, which will be displayed to the operator when record validation is required.