SCOPE

From Recital Documentation Wiki
Jump to: navigation, search

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