freetds AT lists.ibiblio.org
Subject: FreeTDS Development Group
List archive
- From: Peter Deacon <peterd AT iea-software.com>
- To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
- Subject: RE: [freetds] ODBC 'trans2' patch
- Date: Mon, 1 Sep 2003 09:22:44 -0700 (Pacific Daylight Time)
On Mon, 1 Sep 2003, ZIGLIO Frediano wrote:
> Applied!
> Only a question: why "WHILE @@TRANCOUNT > 1 COMMIT COMMIT" and not
> "WHILE @@TRANCOUNT > 0 COMMIT" ? Perhaps to suit all conditions (SET
> CHAINED ON/OFF) ?
Yea, origionally figured if someone had set chained mode on via a query
trancount would always be 1 since a transaction is automatically started
with new queries.
However doing a little more digging 'while @@trancount > 0 commit' works fine.
take care,
Peter
-
RE: [freetds] ODBC 'trans2' patch,
ZIGLIO Frediano, 09/01/2003
- RE: [freetds] ODBC 'trans2' patch, Peter Deacon, 09/01/2003
Archive powered by MHonArc 2.6.24.