Transaction Processing

source1Tamer · Post by **source1Tamer** » Thu Dec 06, 2001 4:23 pm

Hi,
Is there a way to excute the vortex code snippets in transaction mode, so if part of the code fails, all of the code within the transaction fail??
Actually what I'm doing is a delete process from multitables,,, and it's very important to have transaction support, so if I deleted some records successfully from "table1" and failed to delete from "table2", how could I recover changes to "table1" ...

thanks,
Tamer Yousef

source1Tamer · Post by **source1Tamer** » Fri Dec 07, 2001 5:53 pm

any answer??

Post by **Kai** » Fri Dec 07, 2001 6:06 pm

Full automatic transaction rollback in all cases isn't really feasible, because so many types of transactions and failure modes are possible, and the rollback itself may fail for similar reasons as the original transaction (eg. disk/mem/corruption issues).

The best way to implement in this case is probably to save the deleted records from table1 in Vortex -- <SQL> should return them -- and re-insert the ones you can't delete from table2.