Hi Thom,

The SQLRowCount is applicable to UPDATE, DELETE, and INSERT statements only. So I did not try SQLExecDirect with a SELECT.

Normally ODBC API function SQLExecDirect is not used just by itself. If a SELECT statement is executed, there are several other ODBC API functions to be employed to retrieve the results: SQLBindCol, SQlFetch etc.

The Visual FoxPro virtually "spoiled" us with cursors -- they are so fast and convenient comparing to direct API calls.