Help with transactions

[yhgtbfk]

I have tried both the search function and google and I cant find anything that isnt overly technical, or helpful.

What I want to do is:

Begin Transaction

do a
do b
do c

End Transaction

'a' might contain coding consisting of while loops or if statements.

Is this possible?

In other words, I want to run the above code and SQL either all or none (to prevent data loss half way through)

Thank you

 

[Crilen007]

well... could you not use recordsets to verify if the query worked, and if it did then go ahead with whatever you want at the end?

Not really sure what you are looking to do here..