Subject | Triggers technique question |
---|---|
Author | Marcin Bury |
Post date | 2001-08-31T12:07:18Z |
Hi List
I'm currently creating brand new database for new project and I was
wondering about using triggers "before" or "after".
I.e. if I have the table of invoice headers and the table of invoice items,
when the user wants to delete the invoice (don't ask why) I should use
"before delete" or "after delete" trigger to delete invoice items. Are there
any rules, recommendation, safety and stability issues for choosing "before"
or "after" triggers for updating additional tables.
TIA
Marcin
I'm currently creating brand new database for new project and I was
wondering about using triggers "before" or "after".
I.e. if I have the table of invoice headers and the table of invoice items,
when the user wants to delete the invoice (don't ask why) I should use
"before delete" or "after delete" trigger to delete invoice items. Are there
any rules, recommendation, safety and stability issues for choosing "before"
or "after" triggers for updating additional tables.
TIA
Marcin