[freetds] ODBC 'trans2' patch
Peter Deacon
peterd at iea-software.com
Mon Sep 1 10:22:44 EDT 2003
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
More information about the FreeTDS
mailing list