2-05:Format Work Fields Validation Table

Chapter 2-5: Work Fields

Format Work Fields Validation Table

The Validation Table option from the Format Work Fields overlay accesses the Validation Table overlay, shown in Figure 2-5-14. A validation table provides a more powerful alternative to the use of range checks for data validation when there is a known set of values. Through the list feature, it provides the user with visibility of all the possible field values as well as the ability to select the desired value.

Figure 2-5-14. Format Work Fields Validation Table Overlay

You can establish a validation table for any Format work field in the data dictionary. The entries in the table are case-sensitive. If you enter a validation value in all capital letters, an application user must enter the value in all capital letters.

Validation table operations are database-independent. They access a designer-defined table in application design, not data contained in a file in a database, for the range of possible values. As a result, validation does not vary from database to database. It is automatically available to, and exactly the same for, every database that is associated with an application. All validation values are available for review and selection by the end user through the list feature.

The Validation Table overlay contains the following fields:

· Validation Value provides a valid field value. It is case-sensitive and is used for online review, selection, and validation. Note that validation values newly added to the data dictionary are not available to a current APPX user until the user exits and re-enters APPX.

· Seq No provides an identifying number for the associated validation value. It is defaulted by APPX and can be overridden, but it must be unique within a table.. It determines the order in which validation values are presented, both for selection by the user and for editing in application design. APPX assigns the first validation value a number of 1, with additional values assigned a number that is equal to the highest existing sequence number plus 1. APPX does not require that sequence numbers be contiguous within a table.

· GA is an indicator that displays whenever graphical attributes have been defined for this table entry.

The Validation Table overlay contains this option:

· gui attributes is used to define graphical attributes for each validation table entry. See the Defining Graphical Attributes For Validation and Token Table Entries section in Chapter 3-17: Graphical Attributes for more information on this option.

APPX Application Design Manual (01/13/03)