Difference between revisions of "SCOPE"
From Lianjapedia
m (Text replace - "Recital" to "Lianja") |
Helen.george (Talk | contribs) |
||
(2 intermediate revisions by the same user not shown) | |||
Line 1: | Line 1: | ||
Lianja supports the following scope ranges | Lianja supports the following scope ranges | ||
− | + | {| class="wikitable" width="100%" | |
− | {| class="wikitable" | + | !width="20%"|Scope||Description |
− | !Scope||Description | + | |
|- | |- | ||
|||Default scope of the operation, e.g. FOR is all, WHILE is rest. | |||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. | + | |valign="top"|Next||Process next n records. Enter number of records to process, starting from current record. |
|- | |- | ||
− | |All||Process all records. | + | |valign="top"|All||Process all records. |
|- | |- | ||
− | |Record||Process selected record. Enter the record number of the record to process. | + | |valign="top"|Record||Process selected record. Enter the record number of the record to process. |
|- | |- | ||
− | |Rest||Process all remaining records, starting from current record. | + | |valign="top"|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. | + | |valign="top"|First||Process first n records. Enter number of records to process, starting from top of file. |
|- | |- | ||
|} | |} | ||
− | |||
==Example== | ==Example== | ||
Line 43: | Line 41: | ||
list productid, productname for supplierid = 1 | list productid, productname for supplierid = 1 | ||
</code> | </code> | ||
− | |||
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:Reference]] | [[Category:Reference]] |
Latest revision as of 09:58, 5 February 2013
Lianja 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