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

4-10
Syntax of the FORMSPEC Edit Statements
MINLEN
value [" errormsg "]
{GT}
{LT}
{GE}
{LE}
value [" errormsg "]
{EQ}
{NE}
{IN } {
value [ ,value ]... }
{NIN} {
lowvalue:highvalue [ ,lowvalue:highvalue ]...} [" errormsg "]
{
value [ ,lowvalue:highvalue ]... }
MATCH
pattern [" errormsg "]
The Value Parameter
Values used in comparisons may be constants, field names, or expres-
sions.
Examples of these are:
constants Includes values such as "JONES", 123.56,
!9/1/86!, $TODAY, $LENGTH or $EMPTY
fieldnames such as ORDNUM, QTY or NAME
expressions such as 5+10, QTY*UPRICE or 6%TPRICE
Constants. Constants are divided into categories corresponding to the
three main data types: character, numeric, and date. Character type
constants must be enclosed within quotation marks and date constants
between exclamation points. In addition, there are four system-defined
constants:
$TODAY means today's date and is a
date type constant, which means the
DType must be MDY, DMY, or YMD.
$LENGTH means the current field length and is a numeric constant, which
means the DType must be one of the numeric data types, DIG, NUM, or IMP.
$EMPTY means a null value and can be any data type.
$STATE means a two-character abbreviation (upper or lowercase) of the
state code for one of the 50 states or 5 territories of the United
States. It is a
character type constant. The state codes are contained
in a special table provided by VPLUS/V and are listed in Appendix F of
the
VPLUS/V Reference Manual .
The system-defined constants must be compatible with the data type of
thefield to be edited.