MySQL Forums
Forum List  »  Triggers

Re: Enforce business rule with before insert trigger?
Posted by: Roland Bouman
Date: January 04, 2006 07:38PM

Hi again,

I just did a quick test, and it seems my last suggestion is not viable. From what I can tell now, it seems as if the BEFORE and AFTER row trigger are executed right after each other for a single row. My emulation depends on the (wrong) assumption that, for a particular statement, *ALL* the BEFORE events would occur after wich *ALL* the AFTER events would occur. Instead, the BEFORE and AFTER events seem to come in pairs: rec1 BEFORE - AFTER /rec2 BEFORE - AFTER etc. instead of rec 1 BEFORE / rec2 BEFORE / rec1 AFTER etc.

bummer! (ps runnin this on 5.0.18, ubuntu linux)

Options: ReplyQuote

Written By
Re: Enforce business rule with before insert trigger?
January 04, 2006 07:38PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.