BorlandTalk.com

Michael Kochendoerfer · Guest

I have a question in general about transactions. I'm running D7 and SQL2K.
My application needs to open a query, generate some records in another
table, close the query and after that, doing some processing with the newly
created records along with other table data. This all should belong to one
(large) transaction - so if the latter processing fails, the former
creations should be also rolled back.

For this purpose, I'd like to start a transaction at the very beginning and
do a commit at the end. Between that, there are tables opened and closed
and I wonder how the transaction would behave in the case a table is being
written to and then it's closed within an open transaction. Should this be
possible?

As I cannot have multiple transactions within one TADOConnection, I need a
reliable way to accomplish this...

TIA,
Michael