[ |../../index.htm#lansa/l4wtgu02_0120.htm]
You are here:

2.4.1 Range: From value / To value

Mandatory.
Specify a "from" and "to" value for each range that the column will be checked against.
At least one range is required and up to a maximum of 20 ranges can be specified. The range values are checked for type and length compatibility.
Rules
Allowable values are:

• An alphanumeric literal (in quotes) such as 'NSW', 'BALMAIN'.
• A numeric literal such as 1, 14.23, -1.141217.
• Another column name such as CUSTNO, INVNUM, etc. Notice that a column name is not entered as #CUSTNO.
• A system variable name such as *BLANKS, *ZERO, *DATE or any other system variable defined at your installation.
• A process parameter such as *UP01, *UP02, etc.
• System does NOT check that the "from" value is less than "to" value.

Tips & Techniques

• You may wish to use 2.3 List of Values Checks when a small range of values are being checked.

Also See
2.4.2 Range of Values Examples
[ |../../index.htm#lansa/l4wtgu02_0120.htm]