Subject | Re: Trigger Position |
---|---|
Author | Anderson Farias |
Post date | 2006-07-05T15:27:36Z |
--- In firebird-support@yahoogroups.com, "Adam" wrote:
(eg. 'before update') in the same position (eg. zero) ??
I have been reported a problem probably coused by a situation like
that, where the restored database works fine but the origial one seems
not to execute one of the triggers.
I havenĀ“t looked at the DB iet, but my 1st guess is that the origianl
database is executing the triggers in a diferent order then the
restored one and so 'messing up' the logic.
BTW, is there any known issue where a trigger whould not be
executed ?? (bad DB or old fb version for eg.) ??
Regards,
Anderson Farias
> The only time the position is even CONSIDERED is if you have multipleAND, what happens if u have more then 1 trigger of the same type
> triggers of the same type on the same table.
(eg. 'before update') in the same position (eg. zero) ??
I have been reported a problem probably coused by a situation like
that, where the restored database works fine but the origial one seems
not to execute one of the triggers.
I havenĀ“t looked at the DB iet, but my 1st guess is that the origianl
database is executing the triggers in a diferent order then the
restored one and so 'messing up' the logic.
BTW, is there any known issue where a trigger whould not be
executed ?? (bad DB or old fb version for eg.) ??
Regards,
Anderson Farias