SCOPE

From Recital Documentation Wiki
Revision as of 15:57, 3 September 2010 by Yvonnemilne (Talk | contribs)

Jump to: navigation, search

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