Tandem ENFORM 058057, Справочное руководство

Страница: 90 / 312

FIND Statement
Statements
058057 Tandem Computers Incorporated
4–19
Input Elements The output fields receive values from any combination of the following input
elements:
The value of a field from the input record. The assignment to an output-field-name
is optional. When you do not specify the output-field-name, ENFORM assumes it is
the same as the field name from the input record. When the output-field-name is
omitted, the input field name must be fully qualified.
FIND ...
( parts.partnum,
...) ;
The value of a numeric literal. Remember to enclose numeric literals within
parentheses.
FIND ...
(region := (5),
... );
The value of a string literal. A string literal must be enclosed in parentheses.
FIND ...
( jobtitle := ("manager"),
... ) ;
The value of an arithmetic expression. Enclose an arithmetic expression within
parentheses. Use any combination of numeric fields, numeric literals, numeric
user variables, predefined aggregates, or user aggregates for the arithmetic
expression.
FIND ...
( sales := (price * quantity),
... ) ;
The value of an IF/THEN/ELSE expression. Enclose the IF/THEN/ELSE
expression within parentheses.
FIND ...
(stock := (IF inventory GT 100 THEN inventory
ELSE ZERO),
...);
The value of a user variable. Define the user variable by a DECLARE statement
before referencing it in a FIND statement. The SET statement should be used to
initialize the user variable. If the user variable is not initialized, the value is zero.
DECLARE region;
SET region TO 5;
FIND ...
( reg := region,
... ) ;