Enform Plus Reference Manual

Clauses
Enform Plus Reference Manual—422684-001
5-72
WHERE Clause
WHERE Clause
The WHERE clause allows you to restrict the records that contribute to the target file. The
syntax of the WHERE clause is:
logical-expression
is a condition that returns a true or false value. See Logical Expressions on
page 3-22 for more information.
The logical expression in a WHERE clause defines which records are restricted from
contributing to the target file. For example:
WHERE employee; BEGINS WITH "BROWN";
Using the WHERE Clause to Establish a Link
Using the WHERE clause to specify a link causes only those records that satisfy the
condition specified in the logical-expression to be included in the report. The
link created by the WHERE clause remains in effect only for the associated LIST or
FIND statement. For a more complete description of linking, see the LINK Statement
on
page 4-25. The following example shows how the WHERE clause is used to specify a
link:
WHERE parts.partnum EQ odetail.partnum,
WHERE logical-expression