2. Will an ADO sqlTransaction that is begun but not explicitly
committed or rolled back (i.e. the session was terminated before the
transaction could be concluded) be automatically rolled back or
automatically committed by the server?
This question has a rather high "duh" factor to it.
What do you think?
Let's illustrate this with an example:
> update mytable1 set ...
> update mytable2 set...
> insert into mytable3 ...
--> connection broken
Now, does the server know if these are all statements to be
issued in this single transaction? No, it doesn's. So ROLLBACK
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL