Re: [SQL] How to avoid (stop) a endless loop in a trigger

2004-03-04 Thread Oliver Elphick
On Thu, 2004-03-04 at 14:54, Rodrigo Sakai wrote: > Hi people, i have a problem here. > I'm doing a trigger that when a update occurs i need to do an update on the same > table (target table), but as known, it causes a endless loop whithin infinit > updates. So I need to stop the trigger af

[SQL] How to avoid (stop) a endless loop in a trigger

2004-03-04 Thread Rodrigo Sakai
Hi people, i have a problem here. I'm doing a trigger that when a update occurs i need to do an update on the same table (target table), but as known, it causes a endless loop whithin infinit updates. So I need to stop the trigger after it does the first update, is there any way? I t