Page History
The following variables are used for maintaining and querying the status of key lists.
The following variables are used for maintaining and querying the status of key lists. | ||||||||||||||||||||||||||||||||||||||
| Variable | Description | ||||||||||||||||||||||||||||||||||||
@CURSORS | A list of active cursors. | |||||||||||||||||||||||||||||||||||||
@LIST_ACTIVE | The flag that indicates whether there is an active select list in cursor 0, and what type of list it is. |
|
|
| 0 |
|
|
|
| 1
|
|
| 2 |
|
|
| 3 |
| ||||||||||||||||||||
| @PRI_FILE | The file handle for the table represented in cursor zero. | ||||||||||||||||||||||||||||||||||||
@QUERY_DICT | The file handle for the dictionary represented in cursor zero. | |||||||||||||||||||||||||||||||||||||
@RECCOUNT | If there is an active, resolved select list, this variable contains the number of keys in the list. | |||||||||||||||||||||||||||||||||||||
| @REDUCTION_DONE | Contains 1 if the key list in cursor 0 is completely resolved, otherwise it is null. | ||||||||||||||||||||||||||||||||||||
@RN_COUNTER | The ReadNext counter. Incremented for each row examined by the ReadNext statement. It must be initialized by the procedure to a starting value (usually zero). |