Hi Tom, === 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: >>start transaction > 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 it is. With regards, Martijn Tonies Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL Server. Upscene Productions http://www.upscene.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
