SET Options

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.

Examples

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