Field Validation

Before entering a list of generalized codes for a field, you must know the field’s name and size. In the character interface, the field name displays in a pop-up window when you press Ctrl+F with your cursor in the field. If the pop-up window indicates generalized codes validation, the system automatically verifies data entered in the field against the list of generalized codes.

You can also use Generalized Codes Validation Report (36.2.15) to view a list of all fields in the database that have schema validation assigned. This is the preferred method in the QAD .NET UI.

Note: The system performs validation only when generalized codes have been defined for a field.

Example: You have divided your customers into regions. The cm_region in the customer master is updated in Customer Data Maintenance (2.1.1). As part of the implementation process, you assign each customer to one of two regions. To ensure that only standard region codes are used, define them as generalized codes. Specify cm_region for the field name, the values US and X-US for the two regions.

Generalized Codes Maintenance (36.2.13) illustrates Generalized Codes Maintenance (36.2.13).

If you have permission, specify the generalized codes group that this generalized code belongs to. The group the field is currently assigned to is displayed in this field. This field is only relevant if you are using generalized codes groups.

To set up a lookup to display generalized codes, use Drill-Down/Lookup Maintenance (36.4.8.1). Enter the field name where you want the lookup and gplu072.p as the procedure to execute. See Maintaining Drill Downs and Lookups.

This program creates the lookup with values from the assigned field. If the lookup should only be accessed from a particular screen, enter that program name as the calling procedure.

The description defaults from the data dictionary, but can be changed here. If no description exists, the field name is a local variable. The description displays as the title of the lookup.

Note: If you have not defined codes in Generalized Codes Maintenance for a field with generalized codes validation, a lookup icon is displayed next to the field in the QAD .NET UI. If you then define codes for the field, the lookup icon is changed to a drop-down list in which the new codes are selectable. This change is visible when you log out and back in to the system, or when you switch domains.

Generalized code validation, like field security, requires a special validation expression in the database dictionary that references the file gpcode.v.

Some fields already reference gpcode.v. These display in the Generalized Codes Validation Report. If you want to activate generalized code validation for other fields, you must change the data dictionary.

You can do this directly using full Progress or, if you have encrypted source, you can use the utility utdbfx70.p. Once you have added a validation expression, you must recompile the affected programs. For instructions on how to do this, refer to the Progress Programming Handbook.

To add validation for a local variable, you must insert the validation directly in the source code.

Important: If you change the data dictionary, keep careful records and be prepared to repeat the change when new product versions that update the data dictionary are installed.