This shows you the differences between two versions of the page.
Next revision | Previous revision | ||
dev:dbprocs:sqlserver:home [2009/12/07 03:40] tdo created |
dev:dbprocs:sqlserver:home [2016/06/28 22:38] (current) |
||
---|---|---|---|
Line 3: | Line 3: | ||
====== SQL Server Stored Procedure Interface ====== | ====== SQL Server Stored Procedure Interface ====== | ||
The SQL Server Stored Procedure Interface comes in the form of Extended Stored Procedures. | The SQL Server Stored Procedure Interface comes in the form of Extended Stored Procedures. | ||
+ | |||
+ | * [[dev:dbprocs:sqlserver:sample_code | SQL Server Stored Procedure Example ]] | ||
===== Installation ===== | ===== Installation ===== | ||
Line 35: | Line 37: | ||
go | go | ||
</code> | </code> | ||
+ | ===== SQL Server Store Procedure Routines ===== | ||
+ | |||
+ | ^ Routine ^ Description ^ | ||
+ | | [[ dev:dbprocs:sqlserver:odxconnectenv| OdxConnectEnv ]]| Establishes a connection to an Omnidex Environment | | ||
+ | | [[ dev:dbprocs:sqlserver:odxconnectenv| OdxDisconnectEnv ]] | | | ||
+ | | [[ dev:dbprocs:sqlserver:odxconnectenv| OdxConnectEnv ]] | | | ||
+ | | [[ dev:dbprocs:sqlserver:OdxOpenCursor | OdxOpenCursor]] | | | ||
+ | | [[ dev:dbprocs:sqlserver:OdxCloseCursor | OdxCloseCursor ]] | | | ||
+ | | [[ dev:dbprocs:sqlserver:OdxIsConnected | OdxIsConnected ]] | | | ||
+ | | [[ dev:dbprocs:sqlserver:OdxIsOpened | OdxIsOpened ]] | | | ||
+ | | [[ dev:dbprocs:sqlserver:OdxParseSql | OdxParseSql ]] | | | ||
+ | | [[ dev:dbprocs:sqlserver:OdxSetVariable | OdxSetVariable]] | | | ||
+ | | [[ dev:dbprocs:sqlserver:OdxSetColumnType | OdxSetColumnType ]] | | | ||
+ | | [[ dev:dbprocs:sqlserver:OdxExecuteSql | OdxExecuteSql ]] | | | ||
+ | | [[ dev:dbprocs:sqlserver:OdxGetRow | OdxGetRow ]] | | | ||
+ | | [[ dev:dbprocs:sqlserver:OdxGetColumn | OdxGetColumn ]] | | | ||
+ | | [[ dev:dbprocs:sqlserver:OdxGetLastRowCount | OdxGetLastRowCount]] | | | ||
+ | | [[ dev:dbprocs:sqlserver:OdxGetVersion | OdxGetVersion ]] | | | ||
+ | | [[ dev:dbprocs:sqlserver:OdxGetErrorMessage | OdxGetErrorMessage ]] | | | ||
+ | | [[ dev:dbprocs:sqlserver:OdxGetPrimaryKeys | OdxGetPrimaryKeys ]] | | | ||
+ | | [[ dev:dbprocs:sqlserver:OdxGetData| OdxGetData ]] | | | ||
{{page>:bottom_add&nofooter&noeditbtn}} | {{page>:bottom_add&nofooter&noeditbtn}} |