Statement | Effect on Cursor Position |
open | Cursor positioned before first row in set. |
fetch | Cursor moves to next row in set. If it is already on the last row, the cursor moves beyond the set and its position becomes undefined. |
update(cursor) | Cursor remains on current row. |
delete(cursor) | Cursor moves to a position after the deleted row (but before the following row). |
close | Cursor and set of rows become undefined. |