Using VPLUS: An Introduction to Forms Design (32209-90004)

4-6
Table 4-1. Comparison Editing Statements
----------------------------------------------------------------------
| | |
| Statement | Meaning |
| | |
----------------------------------------------------------------------
| | |
| EQ | is equal to |
| | |
| NE | is not equal to |
| | |
| LT | is less than |
| | |
| GT | is greater than |
| | |
| LE | is less than or equal to |
| | |
| GE | is greater than or equal to |
| | |
----------------------------------------------------------------------
Range Check. Another type of edit statement specifies a range of values
within which the entered value must fall. A range statement consists of
IN (
is in ) or NIN ( is not in ) followed by a range of values. The first
value in the range is separated from the last by a colon (:). The first
value must be the lower value.
Possible range checks are:
IN "AAMES":"AZIMOV" Only names between AAMES and AZIMOV
(inclusive) are acceptable in a character
type field.
IN $TODAY: !12/31/86! Only dates between today's date through 1986
can be entered.
NIN 20:50 Values between 20 and 50 are treated as
errors. (Note that this statement indicates
a range of unacceptable values.)
IN 10:20, F1:F4, 100:300 Means the value must be between 10 and 20,
or between the values entered in fields F1
and F4, or between 100 and 300, inclusive.
Table Check. A special case of the range check is a table (or list)
check. This edit determines whether the entered value is one of a set of
values arranged as a table or list. Like the range check, the table
check statement starts with either IN (is in) or NIN (is not in). Unlike
a range check, every value in the table must be listed and separated by
commas. For example, consider the following table checks:
IN 2,4,6,8,10,12,14,16,20 Entered value must be one of the specified
values.
IN 5,10,15,F7+5 Means the value must be 5, 10, 15 or the
current value of field F7 plus 5.