MySQL Forums
Forum List  »  Triggers

Re: Enforce business rule with before insert trigger?
Posted by: Hasani Blackwell
Date: January 04, 2006 12:50PM

Apparently Andrew found a good solution months later --> http://forums.mysql.com/read.php?99,55023,55023#msg-55023


http://mysql.gilfster.com/page.php?parent_id=2&page_id=2.0.7

----------------------------------------------------------------------------------------------------------------


Re: DO NOTHING in a trigger
Posted by: Andrew Gilfrin (IP Logged)
Date: November 17, 2005 08:06AM

Hi Raul,

Seems like I'm on a shamless promotion tour of my latest page update but it seems as if raising an error in the trigger might do the trick.

Depending on how complex the requirements are you can use this method...

http://mysql.gilfster.com/page.php?parent_id=2&page_id=2.0.7

Or this one.

http://www.livejournal.com/users/arjen_lentz/49881.html

--
Andrew Gilfrin
------------------
http://gilfster.blogspot.com
My MySQL related Blog

http://www.mysqldevelopment.com
MySQL Stored Procedure,Trigger, View.... (Just about most things these days) Information

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Enforce business rule with before insert trigger?
3323
January 04, 2006 12:50PM


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.