2020.2

Here is a breakdown of the syntax (all options are mandatory):
l
field(): Always surrounds database field selections.
l
Record Set Number: The data page (or "record") of the data selection.
l
Child Number: Line Number in the record (if there are multiple lines returned for one
single record).
l
Field Name: The name of the field you want to retrieve.
l
Case Option: This can be one of three options:
l
KeepCase: Keeps the current uppercase and lowercase letters as they are.
l
UpperCase: Converts all letters to their uppercase equivalent.
l
LowerCase: Converts all letters to their lowercase equivalent.
l
Trim Option: Can either be "Trim" if you want to trim empty spaces before and after the
data selection or "NoTrim" if you want to retain the extra spaces.
Data Repository lookups
The Data Repository selections are made through the lookup function. Selections are done
from the data located in the "Data Repository Manager" on page839. The lookup function
returns the value of a single key, which is always a string. If the lookup operation fails to find
any data, for any reason, the return value is always "NODATA".
Syntax
lookup(group, return key, lookup key, lookup value)
Here is a breakdown of the syntax (all arguments are mandatory):
l
group: The name of the group in which to retrieve the value. Does not need to be
surrounded by quotes.
l
return key: The name of the key where the information you want to retrieve is located.
Does not need to be surrounded by quotes.
l
lookup key: The name of the key in the group with which to look up the value. The return
key of the KeySet in which the lookup key's value matches the lookup value will be
returned.
l
lookup value: A string surrounded by quotes which will be used in the lookup.
The lookup syntax is akin to a SQL SELECT statement and could be loosely translated to:
Page 55