2 subjobs commit in same transaction

[michaelh1]

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?

[manodwhb · Accepted solution]

@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.