Hi, >>practical benefit to breaking up triggers? 1. separate code logically like procedure 2. you can simply disable it without altering content 3. simplify editing by minimize toxicity
regards, Karol Bieniaszewski -----Oryginalna wiadomość----- From: Gabor Boros [email protected] [firebird-support] Sent: Wednesday, June 28, 2017 2:27 PM To: [email protected] Subject: [firebird-support] Triggers - One big or more smaller? Hi All, The table have a BEFORE UPDATE trigger. Now I need a check before the existing trigger code and raise an exception if needed. I can write the check into the existing trigger before the existing code. But can create a new trigger with a lower position than the existing one. Is there any practical benefit to breaking up triggers? Gabor ------------------------------------ ------------------------------------ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Visit http://www.firebirdsql.org and click the Documentation item on the main (top) menu. Try FAQ and other links from the left-side menu there. Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ ------------------------------------ Yahoo Groups Links --- Ta wiadomość została sprawdzona na obecność wirusów przez oprogramowanie antywirusowe Avast. https://www.avast.com/antivirus ------------------------------------ ------------------------------------ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Visit http://www.firebirdsql.org and click the Documentation item on the main (top) menu. Try FAQ and other links from the left-side menu there. Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ ------------------------------------ Yahoo Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) <*> To change settings via email: [email protected] [email protected] <*> To unsubscribe from this group, send an email to: [email protected] <*> Your use of Yahoo Groups is subject to: https://info.yahoo.com/legal/us/yahoo/utos/terms/
