ODBC/inline driver ignores transactions.

Bob Kline bkline at rksystems.com
Tue Jul 4 10:46:19 EDT 2000

About 450 lines down in his message, Daniel Lynes slipped in the question:

>    /* does anyone know how ODBC deals with multiple result sets? */

After any SQL statement which returns multiple results, the application
is positioned at the first result.  This result can be a result set or a
count of affected rows.  To move to the next result, the application can
call SQLMoreResults(), which returns SQL_SUCCESS[_WITH_INFO] as long as
another results set or count is available.  The driver needs to swallow
any rows in a result set which have not been fetched when moving to the
next result.  When no more results are available, SQLMoreResults()
returns SQL_NO_DATA.

Hope this helps.

Bob Kline
mailto:bkline at rksystems.com

More information about the FreeTDS mailing list