Re: Rolling back transactions

Posted in 1997

Art S. Kagel — Thu, 21 Aug 1997 12:54:36 -0400 — source: Informix-list mailing list archive (1991-1998)

Uday Shankar wrote: > > Hi all, > > I have a situation here which I can't seem to find a satisfactory > > How can I modify this SQL so the transaction is rolled back > on the error ? Since you do not have logging on your database you application must check the error returned by the trigger from the stored procedure's exception trap. You must then explicitely delete the new row that you added. There is no other way without logs. Art S. Kagel