Opens a connection to the database and returns
a numeric handler to be used by other ODBC functions.
|
Function |
Group |
Execution |
Windows |
Embedded |
Thin Client |
| ODBCOpen
|
ODBC |
Synchronous |
Supported |
Not
supported |
Executed on
Server |
Syntax
ODBCOpen( strDsn, strUser, strPassw, strTable, strFilter, strSort )
- strDsn
- The name of the data source.
- strUser
- The user name.
- strPassw
- The password.
- strTable
- The name of the database table
- strFilter
- The SQL WHERE
clause.
- strSort
- The SQL ORDER BY
clause.
Returned value
|
n
|
On
success, returns the handler to identify the database |
| −1 |
Invalid
parameter |
| −2 |
DSN or
TableName contain an empty string |
Notes
This function does not read or write any data; it
simply creates a handle to manipulate the database. You must bind
the columns using the ODBCBindCol function, and then you
must call the
ODBCQuery function to retrieve the first record.
Examples
|
Tag Name |
Expression |
|
Tag |
ODBCOpen( "MyDSNFile", "Alex", "",
"Table1", "Name='Mayer'", "Name ASC" )
|
|
Tag |
ODBCOpen( "DSNFileName", "Robert", "Robot",
"Table1", "", "" )
|