Skip to Content.
Sympa Menu

freetds - Re: ODBC/inline driver ignores transactions.

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Bob Kline <bkline AT rksystems.com>
  • To: TDS Development Group <freetds AT franklin.oit.unc.edu>
  • Subject: Re: ODBC/inline driver ignores transactions.
  • Date: Tue, 4 Jul 2000 10:46:19 -0400 (EDT)


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
http://www.rksystems.com






Archive powered by MHonArc 2.6.24.

Top of Page