CURSORDISPLAY
SET CURSORDISPLAY ON | OFF
ODXSQL ONLY. Use the CURSORDISPLAY set option to toggle the automatic
display of the affected cursor number as its status changes. This applies
to opening and closing cursors and changing the current cursor. The default
setting for this option is OFF.
Cursors are automatically assigned identifying numbers by OmniAccess
as they are opened. By default, these numbers are not displayed to the
OdxSQL window. The CURSORDISPLAY ON set option instructs OdxSQL to display
the cursor number to the window as the cursor is opened.
Example
The CURSORDISPLAY ON set option instructs OdxSQL to display the cursor
number to the window as the cursor is opened.
>OPEN CURSOR
Opened cursor
>SET CURSORDISPLAY ON
>OPEN CURSOR
Opened cursor 2
It also causes OdxSQL to display the new current instance and cursor
numbers if a different cursor is assigned to be the current cursor, or
the affected cursor number if a cursor is closed.
>SET CURSORDISPLAY ON
>OPEN CURSOR
Opened cursor 3
>SET CURSOR 2
Current instance is now 1, and current cursor is now 2
>CLOSE CURSOR
Closed cursor 2
The instance number and cursor number are displayed for connections.
>SET CURSORDISPLAY ON
>connect /users/garment.env
Connected to /users/garment.env on instance 2, cursor 2
Top
|