Thread: triggers

triggers

From
"ALÝ ÇELÝK"
Date:
update trigger  working on same table??? 




Re: triggers

From
Michael Fuhr
Date:
On Mon, Feb 14, 2005 at 05:42:27PM +0200, ALÝ ÇELÝK wrote:
>
> update trigger  working on same table??? 

Could you be more specific, please?  What are you trying to do?

-- 
Michael Fuhr
http://www.fuhr.org/~mfuhr/


Re: triggers

From
PFC
Date:
> update trigger  working on same table???
If an UPDATE trigger does an update on its own table, it can trigger  
itself and explode...


Re: triggers

From
"ALÝ ÇELÝK"
Date:
I mean; there is an update triger on a table.
This trigger must update some other rows(with current row)  on the same 
table. But, it explodes. Is there any way to temprorary prevent the trigger. 
(I want to prevent recursive behavior).



"AL� �EL�K" <ali@verus.com.tr>, haber iletisinde �unlar� 
yazd�:cuqgst$2adi$1@news.hub.org...
> update trigger  working on same table???
>