Difference between revisions of "SCOPE"
From Recital Documentation Wiki
Yvonnemilne (Talk | contribs) |
Yvonnemilne (Talk | contribs) |
||
| Line 23: | Line 23: | ||
==Example== | ==Example== | ||
<code lang="recital"> | <code lang="recital"> | ||
| + | open database southwind | ||
| + | use products order categoryid | ||
| + | seek 2 | ||
| + | list productid, productname while categoryid = 2 | ||
</code> | </code> | ||
Revision as of 11:33, 3 September 2010
Template:YLM todo Recital supports the following scope ranges
| Scope | Description |
|---|---|
| Default scope of the operation, e.g. FOR is all, WHILE is rest. | |
| Next | Process next n records. Enter number of records to process, starting from current record. |
| All | Process all records. |
| Record | Process selected record. Enter the record number of the record to process. |
| Rest | Process all remaining records, starting from current record. |
| First | Process first n records. Enter number of records to process, starting from top of file. |
Example
open database southwind use products order categoryid seek 2 list productid, productname while categoryid = 2