The following ODBC options relate to the use of SQLGetData, and are supported by the ODBC driver:
The options listed in the following table specify how columns can be used in a SQLGetData call.
|SQL_GD_ANY_COLUMN||SQLGetData can be called for any unbound column, including those before the last bound column.
The columns must be called in order of ascending column number unless SQL_GD_ANY_ORDER is also returned.
|SQL_GD_ANY_ORDER||SQLGetData can be called for unbound columns in any order.
SQLGetData can be called only for columns after the last bound column unless SQL_GD_ANY_COLUMN is also returned.
|SQL_GD_BOUND||SQLGetData can be called for bound columns as well as unbound columns.
A driver cannot return this value unless it also returns SQL_GD_ANY_COLUMN.
ODBC supports these options for LOBs in order to provide the most flexible programming model and backward compatibility.