Обсуждение: No of triggers of one single table

Поиск
Список
Период
Сортировка

No of triggers of one single table

От
"Harpreet Dhaliwal"
Дата:
Hi,
Can i have more than one trigger on one single table. Actually I want 2 different events to take place simultaneously and independently after insert.

~Harpreet.

Re: No of triggers of one single table

От
Michael Fuhr
Дата:
On Fri, Apr 06, 2007 at 01:10:13PM -0400, Harpreet Dhaliwal wrote:
> Can i have more than one trigger on one single table. Actually I want 2
> different events to take place simultaneously and independently after
> insert.

What happened when you tried it?

--
Michael Fuhr

Re: No of triggers of one single table

От
Alban Hertroys
Дата:
Harpreet Dhaliwal wrote:
> Hi,
> Can i have more than one trigger on one single table. Actually I want 2
> different events to take place simultaneously and independently after
> insert.

You can, but they won't run simultaneously. They'll run in alphabetical
order.

--
Alban Hertroys
alban@magproductions.nl

magproductions b.v.

T: ++31(0)534346874
F: ++31(0)534346876
M:
I: www.magproductions.nl
A: Postbus 416
   7500 AK Enschede

// Integrate Your World //