js editor
Web development
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 total field.
| В |  Copy Code |
|---|---|
FOR lExpr REPLACE ALL alert WITH "low balance" FOR total < 500 | |
Remarks
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.