Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have two subjobs inserting data in two different tables. What i need is to commit all data in one transaction. How can i achieve this?
1st one is insetring into table authors and 2nd one into table books. but after some testing i noticed that if the second job failed, the first one have already commited rows into first table.
I tried to use tDBConnection for this but its not working as expected as you can see in the picture:
And in the child component if i tick "use an existing connection" the combobox is empty.
Is there any way how to force subjobs commit in one transaction?
@michaelh , You can take the on component ok from sub2 and connect to commit. and You remove the On Subjob ok from tDBconnection to Sub2 job.
@michaelh , You can take the on component ok from sub2 and connect to commit. and You remove the On Subjob ok from tDBconnection to Sub2 job.