INSTANCE
SET INSTANCE n
The INSTANCE set option defines the "current" instance in OdxSQL.
This is the instance contained in the instance element of the status array
and is the instance that will be used by default if no instance is specified
in commands that support an ON INSTANCE n clause.
Each time a connection is made in OdxSQL, an "instance" is
established. Use the INSTANCE set option to switch between the different
instances. Use the CURSORDISPLAY set option to display the instance and
cursor numbers as they are changed.
The current cursor becomes undefined when the instance is set with the
INSTANCE set option, because each instance can have multiple cursors.
However, 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.
Example
The current cursor must also be set when the current instance is set
in this manner.
C:\omnidex\Demodata>odxsql orders.env
Connected to C:\omnidex\Demodata\orders.env
>set cursordisplay on
>connect star.env
Connected to C:\omnidex\Demodata\star.env on instance 2, cursor 2
>set instance 1
Current instance is now 1, however the current cursor is undefined.
>set cursor 1
Current instance is now 1, and current cursor is now 1
Top
|