FOR Clauses

See Also

A FOR clause causes a command to act on each record that meets the specified logical condition. FOR clauses have the following syntax:

FOR lExpr

The following example stores low balance in the alert field of all records that contain less than 500 in the total field.

REPLACE ALL alert WITH "low balance" FOR total < 500

The following table lists commands in which you can use a FOR clause.

Commands That Use FOR Clauses
APPEND FROM ARRAY COUNT LOCATE
APPEND FROM DEFINE PAD RECALL
AVERAGE DELETE REPLACE FROM ARRAY
BLANK DISPLAY REPLACE
BROWSE EXPORT REPORT
CALCULATE FOR( ) SCAN...ENDSCAN
CHANGE INDEX SORT
COPY TO ARRAY LABEL SUM
COPY TO LIST

Using the FOR clause can speed operation of single-table commands. For more information about performance enhancement, see Chapter 15, Optimizing Applications, in the Programmer's Guide.