Difference between revisions of "SCOPE"

From Recital Documentation Wiki
Jump to: navigation, search
(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