ACCEPT Attribute

How to:

Specify Data Validation

ACCEPT is an optional attribute that you can use to validate data that is entered into a field using a MODIFY procedure. For a description of its use with all types of data sources, see Describing an Individual Field. However, ACCEPT has a special option, FIND, that you can use only with FOCUS data sources. FIND enables you to verify incoming data against values stored in another field.

Syntax: How to Specify Data Validation

ACCEPT = list 
ACCEPT = range 
ACCEPT = FIND (sourcefield [AS targetfield] IN file)

where:

list: Is a list of acceptable values. See Describing an Individual Field.
range: Gives the range of acceptable values. See Describing an Individual Field.
FIND: Verifies the incoming data against the values in an index in a FOCUS data source.
sourcefield: Is the name of the field to which the ACCEPT attribute is being applied, or any other field in the same segment or path to the segment. This must be the actual field name, not the alias or a truncation of the name.
targetfield: Is the name of the field that contains the acceptable data values. This field must be indexed.
file: Is the name of the file describing the data source that contains the indexed field of acceptable values.