js editor
Web development
If a Visual FoxPro command has a Scope clause, you can specify a range of records for the command to act on.
The following table describes the clauses you can use for Scope.
| Scope | Description |
|---|---|
|
ALL |
Command affects all records in the table. |
|
NEXT nExpr |
Command affects the next nExpr number of records beginning with the current record. In the following example, the REPLACE command acts on the current record and the two following records:
|
|
RECORD nRecordNumber |
Command affects only the specified record number. In the following example, the REPLACE command acts on record number 5:
|
|
REST |
Command affects a range of records beginning with the current record and ending with the last record in the table. In the following example, the REPLACE command stores a null value in the remaining records:
|
You can also specify record ranges using FOR and WHILE clauses. For more information, see FOR Clauses and WHILE Clauses.