Re: Multiple triggers on the same table

>>>>> "Siotos" == Siotos Evaggelos <sevag_at_eurodyn.com> writes:

 Siotos> Hi to all,

 Siotos> My question is simple. I have two triggers on the same table
 Siotos> that execute the same code. Which one will be executed first?
 Siotos> Consider the case that both triggers are 'before insert or
 Siotos> update or delete'.

I seem to remember reading somewhere there is no guarantee on the order of triggers firing when you have multiple triggers which could fire and that any code which depended on this would be error prone - in short a bad idea (TM).

Tim

-- 
Tim Cross
The e-mail address on this message is FALSE (obviously!). My real e-mail is
to a company in Australia called rapttech and my login is tcross - if you 
really need to send mail, you should be able to work it out!