It depends why step 3 failed.[MySQL] 1: START TRANSACTION 2: WITHDRAW $50 from account 32146. 3: DEPOSIT $50 into account 12345. 4: LOG transfer (date/time/teller/etc...) for auditing. 5: COMMIT TRANSACTION
if this failed at step 3 the transaction would be hung and even if rolled
back by server admin the money would still be gone from account 32146
Have a look at http://www.innodb.com/ibman.php#Error_handling
If you want to rollback the transaction to the beginning on any error, you simply use an 'on error' statement in VB to trap the error, and send a rollback command when the error is detected.
-- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: http://www.nusconsulting.com.au
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]