The SQLExecute Phase of SQLExecDirect

[This is preliminary documentation and subject to change.]

SQLExecute executes a prepared statement by:

• Creating an enumeration of row instances for each table in each of the table definitions.
• Storing the row instance enumeration pointer in the table definition.
• For each invocation of SQLFetch, invoking the Next method on the enumeration, which corresponds to scrolling the cursor forward.

When the client invokes SQLGetData the adapter acts upon the row instance as returned by the most recent Next method call. ODBC uses integers to refer to the columns in the select list of a SELECT statement. This integer is a one-based index into the select list. In implementing SQLGetData, the adapter maps the column to an element in the select list. This element provides all necessary information for accessing the corresponding property in the row instance.