Language Reference Guide : System Classes : CursorObject Class : State Attribute
 
Share this page          
State Attribute
Data Type: smallint
4GL Access: R
The State attribute reflects the current state of the cursor object.
Valid values are:
CS_CLOSED
Specifies that the cursor object has been closed or has never had an open statement executed on it. All newly created cursor objects have this state.
CS_OPEN
Specifies that the cursor object has been opened (with the open statement) but no rows have been fetched
CS_CURRENT
Specifies the state of a cursor object after a successful fetch. The cursor retains this state after a successful cursor update, but does not indicate that a new row has been fetched.
CS_NOCURRENT
Specifies the state of a cursor object after a successful cursor delete statement
CS_NO_MORE_ROWS
Specifies the state of a cursor object after a fetch statement that found no more rows to fetch (that is, all rows had been previously fetched)
CS_OPEN_CACHED
Specifies the state of a cursor after it has been opened implicitly by execution of an execute procedure ... into:cursobj statement, but before any rows have been fetched.
When executing a cursor object against an Ingres database, because the DBMS never returns rows, the first fetch against a cursor in the CS_OPEN_CACHED state results in the state proceeding to CS_NO_MORE_ROWS.
Descriptions of system constant values and their numeric equivalents are listed in Cursor State Settings for CursorObject.
For more information about cursor states, see the Programming Guide.