CURSOR
SET CURSOR n
Sets the currently active cursor to cursor n, when using multiple cursors,
where n is the cursor number. This is the cursor that will be used if
a cursor number is not specified in statements that support an ON CURSOR
n clause. Cursor numbers are assigned automatically as each cursor is
opened. Use the CURSORDISPLAY ON set option to automatically display the
cursor number as the cursor is opened.
The current
instance is automatically set when the cursor is set using the CURSOR
set option, because each cursor is associated with a single instance.
However, the current cursor becomes undefined when the instance is set
with the INSTANCE set option, because each instance can have multiple
cursors.
Example
$ odxsql orders.env
Connected to environment orders.env
>SET CURSORDISPLAY ON
>OPEN CURSOR
Opened cursor 2
>SET CURSOR 1
Current instance is now 1, and current cursor is now 1
Top
|