> For any given table, there are 12 possible triggers:
>- 3-choice for insert,delete,update
>- 2 choice for before/after
>- 2 choice for row/statement
Actually, 12 possible TYPES of triggers. In 7.2.2.3 (I think that's the
right version) you can have more than one of each type - if so, the firing
order seems to be last-compiled = first fired. Better than alphabetical
order, I guess.
How about version control and triggers? We wrote a utility that diffs
what's in the database with what's in sccs. Any commercial solutions for
this? Any non-commercial great ideas?