[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