|
Stored Procedures |
SQL Server |
|
OdxGetRowOdxConnectEnv establishes a connection to an Omnidex Environment Catalog via an Omnidex data source file. An instance number is returned in the @instance output parameter. This instance number can be used for all subsequent interaction with the environment catalog, until OdxDisconnectEnv is called.
SyntaxOdxConnectEnv @filename, @instance output[, @options, @username, @pwd] @filename varchar input @instance integer output @options varchar input @username varchar input @pwd varchar intput
Options
See OACONNECT for more options.
ExampleThis example takes a connection string as input from the calling procedure, establishes a connection, opens a cursor and returns the instance number, cursor number and status. CREATE PROCEDURE prODXConnect -- Open a cursor
|
|
APIs | SQL Reference | Stored Procedures | Third Party Tools | Debugging |
OmniAccess API |
ODBC |
JDBC |
Nested Queries |
SET Operations |
WITH Options |
CURSOR / INSTANCE |
Commands |
Functions |
SQL Server |
Oracle |
MS Access |
Ms Excel |