Skip to Content.
Sympa Menu

freetds - RE: [freetds] ODBC 'trans2' patch

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • 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




Archive powered by MHonArc 2.6.24.

Top of Page