 |
 |
|
|
       |
|||
| SQL_Handle_type |
|
|
|
|||||||||||
|
|||||||||||
The SQL_Handle_type OMX component, in conjunction with SQL_Array_type and SQL_Vector_type OMX components, allows you to access an ODBC-compliant database from within an OmniMark program. The SQL_Handle_type OMX component stores task-specific ODBC information.
The OmniMark ODBC dynamic link library file ("omodbc.dll" or "omodbc.so") creates the SQL_Handle_type OMX component. The related include file ("omodbc.xin") defines the interface to that component. To use SQL_Handle in your program, you must include the following declaration and include statement in your program:
include "omodbc.xin"
Within your program, you can create as many instances of the SQL_Handle_type component as you require by declaring global and local variables of type "SQL_Handle_type". For example:
; required declaration and include statements
include "omodbc.xin"
; global SQL_Handle_type declarations
global SQL_Handle_type my-sqlhandle-1
global SQL_Handle_type my-sqlhandle-2
process
; local SQL_Handle_type declarations
local SQL_Handle_type my-sqlhandle-2
local SQL_Handle_type my-sqlhandle-3
Once you have declared your SQL_Handle_type variables, you manipulate them using the functions in the OmniMark ODBC function library.
The SQL_Handle_type OMX component is not copyable. This means that when you set the value of one SQL_Handle_type OMX variable to the value of another SQL_Handle_type OMX variable, you end up with two variables both pointing at the same external object. You are able to manipulate both variables, but you are performing those manipulations on the same external object, whether you use the original SQL_Handle_type OMX variable or its copy.
| ---- |
