Enform Plus Reference Manual

Statements
Enform Plus Reference Manual—422684-001
4-20
Input Elements
•
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),
...);
•
he 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,
... ) ;
•
The value of either a user aggregate or a predefined aggregate.
FIND ...
( BY employee.job,
employee.salary,
rate := AVG (salary OVER job),
... ) ;
•
A group name. Enform Plus allows you to specify a group name as an input element.
Avoid this specification, however, unless the data type of the fields receiving the
data is exactly the same as the data type of the input group.
Although Enform Plus allows you to specify an output field name as an input element,
this specification is not recommended and might lead to unexpected results.
The following rules apply to input elements:
•
An input element can be qualified or subscripted.
•
An input element cannot contain a subscript range.