Welcome to the nuBuilder forums!

Please register and login to view forums and other content only available to registered users.

Triggers - ok or what?

Post Reply
martbarr
Posts: 60
Joined: Fri Oct 26, 2012 8:09 pm

Triggers - ok or what?

Unread post by martbarr »

Am I ok using triggers in mysql db?

I assume that nuBuilder doesn't use them for it's work, but is there a reason I need to avoid or anything to watch out for?
For example I'm keeping a 1:1 table with the current Postal Address for a record - this being calculated with various parameters.
At the moment I do this with AfterSave php which is fine, but occurs to me that I might do it with a trigger more easily.
Have also starting looking at audit trails for record changes and a trigger may make this very simple.

Any gotchas ?

Thanks
Martin
admin
Site Admin
Posts: 2781
Joined: Mon Jun 15, 2009 2:23 am
nuBuilder Version: 4.5
Been thanked: 1 time

Re: Triggers - ok or what?

Unread post by admin »

Martin,

Not that I'm aware of.

Steven
Post Reply