Share via


FOR Clauses

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 Optimizing Applications.

See Also

REPLACE Command | Scope Clauses | WHILE Clauses | Field and Record Manipulation | Data Manipulation