| Subject | Re: [firebird-support] update trigger do not fire |
|---|---|
| Author | Ann W. Harrison |
| Post date | 2005-02-26T18:14:09Z |
Michel.Francoeur@... wrote:
the operation because the operation has already been done. Meaning, in
concrete terms, that the record has already been updated when your
trigger fires, so nothing that trigger does will affect the contents of
the record. Use "after" operation triggers for logging and validation.
Use "before" triggers to clean-up data going into the target record.
Regards,
Ann
> We have tried a to update a table with a after update trigger an it doesNot exactly. "After" operation triggers don't change the values used in
> not seem to fire. We have Firebird/hpux800 (access method), version
> "HU-T6.2.697 Firebird Release Candidate 2". Is it a known problem?
the operation because the operation has already been done. Meaning, in
concrete terms, that the record has already been updated when your
trigger fires, so nothing that trigger does will affect the contents of
the record. Use "after" operation triggers for logging and validation.
Use "before" triggers to clean-up data going into the target record.
Regards,
Ann