How to: |
The functionality of ACCEPT in a Master File has been extended. When placed on a FIELD declaration, it can be used to control the values that show up in a filter (WHERE) dialogue box. When used with a global amper variable in the Master File, it can be used to control the values displayed by the Amper Auto-Prompting facility.
The ACCEPT attribute supports the following types of operations:
This option is used to specify one or more acceptable values.
This option is used to specify a range of acceptable values.
This option is used to validate incoming transaction data against a value from a FOCUS data source when performing maintenance operations on another data source. FIND is only supported for FOCUS data sources and does not apply to OLAP-enabled synonyms. Note also that, in the Maintain environment, FIND is not supported when developing a synonym.
This option is used to supply pairs of values for auto amper-prompting. Each pair consists of one value that can be looked up in the data source and a corresponding value for display.
This option is used to retrieve pairs of values by running a FOCEXEC. Each pair consists of one value for lookup in the data source and a corresponding value for display.
This option is used to look up values in another data source and retrieve a corresponding display value. The lookup field values must exist in both data sources, although they do not need to have matching field names. You supply the name of the synonym, the lookup field name and the display field name.
ACCEPT=SYNONYM(lookup_field AS display_field IN lookup_synonym)
where:
Is the field in the lookup_synonym whose value will be used in the filter (WHERE dialogue) or by the amper autoprompt facility that will be compared with the field that has the ACCEPT attribute.
Is the field in the lookup_synonym, whose value will be displayed for selection in the filter dialogue or amper autoprompt drop-down list.
Is the name of the synonym that describes the lookup data.
iWay Software |