Enform Plus Reference Manual

Statements
Enform Plus Reference Manual—422684-001
4-22
Statements and Clauses That Do Not Apply to the
FIND Statement
If you want summary records that consist of only by-items and aggregates to include
those where the last value of a by-item has not changed but a subordinate by-item
value has changed, then you must include a target-item in the target-list that
has not appeared as a by-item or aggregate. Of course, you must also set
@SUMMARY-ONLY to OFF. For example:
SET @SUMMARY-ONLY TO OFF;
FIND findfil2
(BY employee.dept,
BY employee.job,
BY employee.empname,
employee.salary,
numemp:= COUNT (empname OVER job));
Statements and Clauses That Do Not Apply to the FIND Statement
Enform Plus queries with a FIND statement produce records only. There are no report
features such as headings, titles, summary information, and special formatting. The
following statements and clauses apply only to queries using the LIST statement and
cannot be used with the FIND statement.
AFTER CHANGE clause
AS clause
AS DATE clause
AS TIME clause
AT END statement and AT END PRINT clause
AT START statement and AT START PRINT clause
BEFORE CHANGE clause
CENTER clause
CUM clause
FOOTING statement and clause
FORM clause
HEADING clause
NOHEAD clause
NOPRINT clause
PCT clause
SKIP clause
SPACE clause
SUBFOOTING statement and clause
SUBTITLE statement and clause
SUBTOTAL clause
System Variable clauses
TAB clause
TITLE statement and clause
TOTAL clause