USE SINGLE VALUE COMPARISONS [ USING VPLUS/V AN INTRO. TO FORMS DESIGN Self-Paced Training Guide ] MPE/iX 5.0 Documentation
USING VPLUS/V AN INTRO. TO FORMS DESIGN Self-Paced Training Guide
USE SINGLE VALUE COMPARISONS
Now that you understand how to use the FIELD TOGGLE, lets add some
processing specifications to the field. The first type of field edit you
will use is a single value comparison.
Action
Press FIELD TOGGLE. Type the field edit statement EQ $TODAY in the lower
menu, as shown in Figure 4-4. Press ENTER.
The statement EQ $TODAY is one possible comparison. It means that the
data entered in the field must be today's date. Other single value
comparisons you could enter in a date field include:
GE !1/1/86! Entered date must be in 1986 or a subsequent
year.
LT $TODAY Entered date must be earlier than today's
date.
Figure 4-5. Field Menu for QTY in the ORDER Form
Single value comparisons can also be used for other fields of the form.
If you want to ensure that the number of parts ordered is one or more,
you use the GE statement to test that the data entered is greater than or
equal to one.
Action
Use NEXT to display Field Menus until the Field Menu for QTY is
displayed. Press FIELD TOGGLE. Type GE 1 in the lower menu, as shown in
Figure 4-5. Press ENTER.
Note that the data type of the QTY field was set to DIG in a prior
exercise. (Section 3). It could be any other numeric type, but not a
CHAR type or one of the date types.
MPE/iX 5.0 Documentation