Board index » cppbuilder » Non Nesting Transactions
Non Nesting Transactions
2003-10-02 05:40:59 AM
Imagine if you will:
User opens Form1 and changes some data (which automatically starts a
transaction) but before commiting the changes he opens Form2 and changes
data (again automatically starting a transaction (which I guess is
considered nested)) but before commiting this he opens Form3 starting a new
transaction ......... Now the user accept changes in FormN......, Form3 and
Form2 but realises that he has messed up the data on Form1 so decides not to
As I understand transactions the rollingback on Form1 will rollback the
already commited transactions on Form2, Form3...FormN, is this correct?
More to the point is there any way I can use the above model but start new
transactions that are independent of each other?
PS Just to clarrify, code in the forms start the transactions when it is
detected that data has changed, this is because tracking changes with the
aim of performing a batch update on the forms data would be a massive job.