triggering in 7.31
An update trigger was created on a few fields of a table. The trigger is activated even if another field is updated. Is this a bug in 7.31.FC6? Thanks
↪ replying to ECS
On Sep 24, 7:36 am, "ECS" <z...@mailinator.com> wrote: > An update trigger was created on a few fields of a table. > The trigger is activated even if another field is updated. > Is this a bug in 7.31.FC6? > > Thanks I believe a trigger is created on a table, not on a field(column) of a table. If you have an update trigger on the table the trigger will be activated every time the table is updated. It should only take the action documented in the trigger if the fields affect change appropriately.