CodeBase SQL/ODBC fully conforms to the ODBC version 2.5 specification for Core API and Level 1 API, and supports most of the Level 2 function calls. The following table lists the ODBC API functions supported by CodeBase SQL/ODBC.
| ODBC Function | Conformance Level |
| SQLAllocConnect | Core |
| SQLAllocEnv | Core |
| SQLAllocStmt | Core |
| SQLBindCol | Core |
| SQLBindParameter | Level 1 |
| SQLBrowseConnect | Level 2 |
| SQLCancel | Core |
| SQLColAttributes | Core |
| SQLColumns | Level 1 |
| SQLColumnPrivileges | Level 2 |
| SQLConnect | Core |
| SQLDataSources | Level 2 |
| SQLDescribeCol | Core |
| SQLDescribeParam | Level 2 |
| SQLDisconnect | Core |
| SQLDriverConnect | Level 1 |
| SQLDrivers | Level 2 |
| SQLError | Core |
| SQLExecDirect | Core |
| SQLExecute | Core |
| SQLFetch | Core |
| SQLForeignKeys | Level 2 |
| SQLFreeConnect | Core |
| SQLFreeEnv | Core |
| SQLFreeStmt | Core |
| SQLGetConnectOption | Level 1 |
| SQLGetCursorName | Core |
| SQLGetData | Level 1 |
| SQLGetFunctions | Level 1 |
| SQLGetInfo | Level 1 |
| SQLGetStmtOption | Level 1 |
| SQLGetTypeInfo | Level 1 |
| SQLMoreResults | Level 2 |
| SQLNativeSql | Level 2 |
| SQLNumResultCols | Core |
| SQLNumParams | Level 2 |
| SQLParamData | Level 1 |
| SQLPrepare | Core |
| SQLPrimaryKeys | Level 2 |
| SQLProcedures | Level 2 |
| SQLProcedureColumns | Level 2 |
| SQLPutData | Level 1 |
| SQLRowCount | Core |
| SQLSetConnectOption | Level 1 |
| SQLSetCursorName | Core |
| SQLSetStmtOption | Level 1 |
| SQLSpecialColumns | Level 1 |
| SQLStatistics | Level 1 |
| SQLTables | Level 1 |
| SQLTablePrivileges | Level 2 |
| SQLTransact | Core |
Exceptions To ODBC Conformance
The following section contains details on the exceptions to ODBC API conformance as specified in Table 1.
SQLMoreResultsCodeBase SQL/ODBC always returns sql_no_data_found for this function. CodeBase SQL/ODBC supports this function, with its return value, due to requirements of Microsoft Access.
SQLSetStmtOption / SQLGetStmtOption
The following table lists the options CodeBase SQL/ODBC supports for SQLSetStmtOption and SQLGetStmtOption:
fOption
(numerical value)vParam Comments SQL_MAX_ROWS(1) See ODBC Programmer’s Reference. SQL_NOSCAN(2) See ODBC Programmer’s Reference. SQL_MAX_LENGTH(3) See ODBC Programmer’s Reference. SQL_Async_Enable(4) See ODBC Programmer’s Reference. SQL_Cursor_Type(6) See ODBC Programmer’s Reference. SQL_Concurrency(7) See ODBC Programmer’s Reference. SQL_Rowset_Size(9) See ODBC Programmer’s Reference. 1151 in the format: Tablename,Password(no space between the Tablename and the Password) A CodeBase SQL/ODBC extension: appends password for table to an internal list in CodeBase SQL/ODBC so that the user will not have to be prompted for the password. 1153 0 (default) turns off table locking;
1 turns on table locking.A CodeBase SQL/ODBC extension: When vParam is set to 1, all tables used by the hStmt are exclusively locked when a select statement is executed on the hStmt. The tables remain locked until the hStmt is dropped (by calling SQLFreeStmt with the SQL_DROP option) or the option is set to DEFLOCK and the hStmt is re-executed. Locked tables can only be used by the locking hStmt; they cannot be used by any other hStmts. Table 2: Options for SQLSetStmtOption and SQLGetStmtOption
SQLSetConnectOption and SQLGetConnectOptionThe following table lists the options CodeBase SQL/ODBC supports for SQLSetConnectOption and SQLGetConnectOption:
SQLSpecialColumns
Table 3: CodeBase SQL/ODBC Grammar Conformance fOption
(numerical value)vParam Comments SQL_ACCESS_MODE(101) See ODBC Programmer’s Reference. SQL_AUTOCOMMIT(102) See ODBC Programmer’s Reference. SQL_CURRENT_QUALIFIER(109) Valid with SQLGetConnectOption. Returns the current table qualifier. For setting a table qualifier, use the use statement. CodeBase SQL/ODBC uses unique indexes as the optimal set of columns that uniquely identifies a row in the table. CodeBase SQL/ODBC cannot identify columns that are automatically updated when any value in the row is updated by a transaction.
SQL Conformance
The ODBC version 2.5 specification provides three levels of SQL grammar conformance: Minimum, Core, and Extended.
Each higher level provides more fully-implemented data definition and data manipulation language support. CodeBase SQL/ODBC fully supports the Minimum SQL grammar, as well as many Core and Extended grammar statements. CodeBase SQL/ODBC support for SQL grammar is summarized in the following table.
Weitere Informationen:
Table 4: CodeBase SQL/ODBC Grammar Conformance SQL Grammar Statement Minimum Core Extended Create Index • Create Table • Create View • Delete (searched) • Drop Index • Drop Table • Drop View • Insert • Left Outer Join • Select • - approximate numeric literal • - between predicate • - correlation name • - date arithmetic • - date literal • - exact numeric literal • - extended predicates • - in predicate • - set function • - time literal • - timestamp literal • Subqueries • Unions • Update (searched) • Use (this is an extension to ODBC SQL grammar) • CodeBase ODBC-Treiber - allgemeine Informationen
CodeBase - allgemeine Informationen
CodeBase - technische Daten
CodeBase - Fragen und Antworten
Copyright 1998 ComFood Software GmbH, alle Rechte vorbehalten
Autor: Dr. Thomas Grüter
