What I wanted to know was if there's a possibility for manually rolling back the transaction. And as I see it seems to be the stop statement ;-).
Thanx a lot. Mathias -----Original Message----- From: Anhaus, Thomas [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 06, 2004 12:21 PM To: Stoedtler, Mathias; [EMAIL PROTECTED] Subject: AW: Triggers Mathias Stoedtler wrote : > >Hello, > >As I got to know "before" triggers are not allowed in MaxDB. What >happens if I create an "after" trigger for a table and raise an STOP in >it? For example after an Update, if there's a wrong value somewhere. Is >the update statement that triggers the execution of my trigger rolled >back? Can I somehow avoid that this update is done in the trigger? > >Hope somebody can help me. > >Regards and thanx, > Mathias > The update statement that fired the trigger will be rolled back, if the trigger fails. The trigger fails, if it returns via a stop statement having an argument != 0. Sorry, but I don't understand the second question. Maybe you can give me an example ? Best Regards, Thomas -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
