SQLNum Result Cols and SQLDescribe Col will be called on the results set at various times.
SQLSet Param is used extensively for binding parameter data and DATA_AT_EXEC functionality.
SQLBind Col is used extensively to register output Column data storage locations with ODBC.
Two SQLGet Data calls are used to retrieve SQL_LONG_VARCHAR and SQL_LONG_VARBINARY data.
NOTE]The following technical note has not been updated since it was first included in the online documentation.
As a result, some procedures and topics might be out of date or incorrect.
Therefore, the few SQLSet Pos statements are always applied to row 1 of the rowset.'s are required, multiple HDBCs per HENV must be supported. This is reflected in a SQLSet Connections call SQL_ODBC_CURSORS, SQL_CUR_USE_ODBC.
SQLDriver Connect, SQL_DRIVER_COMPLETE is used by and its dependent recordsets, SQLGet Info SQL_CURSOR_COMMIT_BEHAVIOR and SQL_CURSOR_ROLLBACK_BEHAVIOR must have SQL_CR_PRESERVE.The new home for Visual Studio documentation is Visual Studio 2017 Documentation on docs.The latest version of this topic can be found at TN042: ODBC Driver Developer Recommendations.The Cursor Library can detect this, and will cache rows from the driver and present them as requested on FETCH_PREV calls in SQLExtended Fetch.Another important example of cursor library dependence is positioned updates.SQLGet Info, SQL_SCROLL_OPTIONS must support SQL_SO_STATIC.