I have some unbound forms that I want to use transaction wrappers on when
updating the table. My question is on the scope of what transaction
processing will do. I'm going to keep it simple with the following code:
Code:
------------------------------------------------------------------------------
--
ws.BeginTrans
bInTrans = True
'Delete record from TableA
rs.Delete
'Now update TableB
Call WriteMasterTableRecord(RecordtoDelete, ValueA, ValueB)
'Now update some information in TableC
Call StatusAsMaster(MasterID, ValueD)
ws.CommitTrans
bInTrans = False
------------------------------------------------------------------------------
--
Again, the code has been simplified.
What I want to know is if the transaction wrapper for TableA also covers
TableB and TableC which are updated in other procedures. In my exit handler
there is the following:
If bInTrans = True Then
ws.Rollback
End If
So, if an error occurs, the Error_Handler is invoked and then the exit
handler. Will the Rollback statement roll back the changes to all three
tables (A, B and C) or will it only roll back Table A??
--
Message posted via http://www.accessmonster.com