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]
