> I just want to know what are the situations wherein I have to write more
> than one trigger for a certain event. Base on my experience, from what I
> have done so far I think I can put it in only one trigger. Is there any
> situtation where it really requires more than one trigger for a certain
> event? or it is just for easy developing, reading, and debugging triggers?

For example for third-party tools that create a log trigger
inside your database, so it doesn't need to modify existing
triggers. It's indeed VERY USEFUL. ;-)


Best Regards,
Thomas Steinmaurer

Logging/Auditing Suite for InterBase and Firebird
http://www.iblogmanager.com
Logging/Auditing Suite for Advantage Database Server
http://www.adslogmanager.com