Difference between revisions of "SCOPE"
From Recital Documentation Wiki
Yvonnemilne (Talk | contribs) |
Yvonnemilne (Talk | contribs) |
||
| (7 intermediate revisions by one user not shown) | |||
| Line 1: | Line 1: | ||
| − | { | + | Recital supports the following scope ranges |
| + | |||
| + | |||
| + | {| class="wikitable" | ||
| + | !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== | ||
| + | <code lang="recital"> | ||
| + | open database southwind | ||
| + | use products order categoryid | ||
| + | // Default current record | ||
| + | display productid, productname | ||
| + | // All records | ||
| + | display all productid, productname | ||
| + | // Default all records | ||
| + | list productid, productname | ||
| + | // Default, process rest of records from current position stopping when record | ||
| + | // does not match the condition | ||
| + | seek 2 | ||
| + | list productid, productname while categoryid = 2 | ||
| + | // Specific record (record 10 here) | ||
| + | display record 10 productid, productname | ||
| + | // First 10 records from top of file (indexed order here) | ||
| + | list first 10 productid, productname | ||
| + | // Next 20 records from current position (indexed order here) | ||
| + | list next 20 productid, productname | ||
| + | // Process all records, listing those that match the condition | ||
| + | list productid, productname for supplierid = 1 | ||
| + | </code> | ||
| + | |||
| + | |||
| + | [[Category:Documentation]] | ||
| + | [[Category:Reference]] | ||
Latest revision as of 16:15, 3 September 2010
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 productid, productname // All records display all productid, productname // Default all records list productid, productname // Default, process rest of records from current position stopping when record // does not match the condition seek 2 list productid, productname while categoryid = 2 // Specific record (record 10 here) display record 10 productid, productname // First 10 records from top of file (indexed order here) list first 10 productid, productname // Next 20 records from current position (indexed order here) list next 20 productid, productname // Process all records, listing those that match the condition list productid, productname for supplierid = 1
