Difference between revisions of "SCOPE"
From Recital Documentation Wiki
Yvonnemilne (Talk | contribs) |
Yvonnemilne (Talk | contribs) (→Example) |
||
Line 25: | Line 25: | ||
open database southwind | open database southwind | ||
use products order categoryid | use products order categoryid | ||
+ | // Default current record | ||
+ | display | ||
+ | // Default all records | ||
+ | list | ||
+ | // Default, process rest of records from current position stopping when record | ||
+ | // does not match the condition | ||
seek 2 | seek 2 | ||
list productid, productname while categoryid = 2 | list productid, productname while categoryid = 2 | ||
+ | // First 10 records from top of file (indexed here) | ||
+ | list first 10 | ||
+ | // Next 20 records from current position | ||
+ | list next 20 | ||
+ | // Last 10 records (indexed here) | ||
+ | list last 10 | ||
+ | // Process all records, listing those that match the condition | ||
+ | list for supplierid = 1 | ||
</code> | </code> | ||
Revision as of 15:57, 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 // Default current record display // Default all records list // Default, process rest of records from current position stopping when record // does not match the condition seek 2 list productid, productname while categoryid = 2 // First 10 records from top of file (indexed here) list first 10 // Next 20 records from current position list next 20 // Last 10 records (indexed here) list last 10 // Process all records, listing those that match the condition list for supplierid = 1