ACCEPT Attribute

How to:

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.


Top of page

x
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.


Information Builders