March 19th, 2004, 07:45 AM
|
 |
Contributing User
|
|
Join Date: Feb 2004
Location: Belgium, Antwerp
Posts: 177
Time spent in forums: 24 sec
Reputation Power: 5
|
|
trigger infinite loop
The following trigger gives me an "nesting limit exceded error" (in other words an infinate loop) 
the trigger is recursive but the recod i tested it out on had only 3 child rows, since no other triggers are active on that field, there is no way it could have gotton up to 32 al on it's own  , or am i wrong 
any help would be appriciated
PHP Code:
CREATE TRIGGER dbo.Optionaliteit_Cascade
ON dbo.Offerte_Lijnen
AFTER UPDATE
AS
IF UPDATE(Optioneel)
BEGIN
UPDATE Offerte_Lijnen
SET Optioneel = (SELECT inserted.Optioneel FROM inserted)
WHERE Parent_ID IN (SELECT inserted.Lijn_ID FROM inserted)
END
|
ASP Free Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
