Hello to alan, county bas association and pittsburgh pennsylvania.

I do have an problem with tableupdate or any updation statements.
Let me explain breifly my problem.
I have begin trans and end trans statements
with in this say for example i got an error which doesnt go to end transaction but hangs in between how do i revert the changes. Because if the system hangs in between it wont proceed further.

Statements in between begin and end trans are insert,update and delete statements basically to add or modify or delete new records.
I am ashwath an indian working in malaysia for an usa based company from atlanta.
I have 2 and half years of experience in automated resource management system basically designed for an engineering company which has premier products like flowmeters.


Regards,
Ashwath.