MDAC 2.5 SDK - Visual FoxPro ODBC Driver


 

ODBC API Functions

Each API function discussed in this section provides a brief summary and any Visual FoxPro–specific details. The ODBC API functions have been divided into three main categories: Core Level API functions, Level 1 API functions, and Level 2 API functions.

Note   Several of the functions behave differently depending on whether the data source is defined as a connection to a directory of free tables (.dbf files) or to a Visual FoxPro database (.dbc file). Certain operations are supported only for database connections.

Core Level API Support

The ODBC Core Level API functions are listed below; all of these functions are supported by the Visual FoxPro ODBC Driver:

SQLAllocConnect SQLExecute
SQLAllocEnv SQLFetch
SQLAllocStmt SQLFreeConnect
SQLBindCol SQLFreeEnv
SQLCancel SQLFreeStmt
SQLColAttributes SQLGetCursorName
SQLConnect SQLNumResultCols
SQLDescribeCol SQLPrepare
SQLDisconnect SQLRowCount
SQLError SQLSetCursorName
SQLExecDirect SQLTransact

Level 1 API Support

The ODBC Level 1 API functions are listed below; all of these functions are fully or partially supported by the Visual FoxPro ODBC Driver:

SQLBindParameter SQLGetTypeInfo
SQLColumns SQLParamData
SQLDriverConnect SQLPutData
SQLGetConnectOption SQLSetConnectOption
SQLGetData SQLSetStmtOption
SQLGetFunctions SQLSpecialColumns
SQLGetInfo SQLStatistics
SQLGetStmtOption SQLTables

Level 2 API Support

The following ODBC Level 2 API functions are fully or partially supported:

The following Level 2 API functions are not supported:

For more detail about any ODBC API function, refer to Chapter 21, ODBC API Reference, in the ODBC Programmer's Reference.