Re: Enforce business rule with before insert trigger?

[Andrew Gilfrin]

Yes this does work, but....

Firstly it works on the premis that the table your using has a primary key constraint, also when the trigger fails it will return back to the calling program and use the primary key error message. This may be fine when your developing but it's really not a solution I would want to implement in a 'real' application.

The reason I'm against doing this is because it gives you no feedback on why the trigger failed, fine in a small trigger but not for a more complex one.

Lets say your trigger failed, which one of the 4 possible scenarios did it fail on? I can imagine the amount of time wasted by a support team looking for why the users inserts are failing a primary key check when it looks fine.



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



Edited 1 time(s). Last edit at 04/27/2005 04:16AM by Andrew Gilfrin.