A FOR clause causes a command to act on each record that meets the specified logical condition. FOR clauses have the following syntax:
The following example stores
low balance in the
alert field of all records that contain less than 500 in the
FOR lExpr 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
Using the FOR clause can speed operation of single-table commands. For more information about performance enhancement, see Optimizing Applications.