Versions Compared

Old Version 3

changes.mady.by.user SRP Support

Saved on

compared with

New Version Current

changes.mady.by.user Corby Nagel

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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.

Flag

Value

 0

 No select list active.

 1

Latent table-based list active.

 2

Latent index-based list active.

 3

Resolved list active.

@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).