CursorObject Attributes
The CursorObject class has three attributes that provide status information:
State
Contains information about the state of the cursor, such as whether it is open or closed
RowCount
Indicates how many rows have been fetched successfully by the cursor since the cursor was opened. When a cursor is opened, RowCount is set to 0. Each subsequent successful fetch statement for that cursor increments RowCount by 1.
When you close the cursor, the RowCount attribute is not reset to 0; it retains whatever value it had before the close statement executed. It is reset only if you reopen the cursor.
DBSession
Identifies the session in which the cursor was opened. After you open a cursor, all subsequent cursor operations for that cursor automatically take place in the session in which the cursor was opened. If the frame is working in a different session, OpenROAD automatically switches sessions for the cursor operation and switches back when the cursor statement completes.