Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Incident Reports » Incident Reports Addressed for Version 2.02 » View Incident Report |
Serious |
Reported By: Fernando Dias Reported On: 2/28/2009 For: Version 2.02 Build 8 |
SCRIPT BEGIN DECLARE Cur1 CURSOR WITHOUT RETURN FOR Sql1 ; DECLARE CurX CURSOR WITH RETURN FOR SqlX; DECLARE TriggerName VARCHAR; -- Drop Triggers PREPARE Sql1 FROM 'SELECT Name FROM Information.Triggers WHERE TableName = ''TblX'''; OPEN Cur1; FETCH FIRST FROM Cur1(Name) INTO TriggerName; WHILE NOT EOF(Cur1) DO EXECUTE IMMEDIATE 'DROP TRIGGER "'+TriggerName+'" FROM TblX'; FETCH NEXT FROM Cur1(Name) INTO TriggerName; END WHILE; UNPREPARE Sql1; -- Delete all rows from test table EXECUTE IMMEDIATE 'DELETE FROM TblX'; EXECUTE IMMEDIATE 'ALTER TABLE TblX ALTER Id RESTART WITH 0'; -- 1. Create the BEFORE INSERT Trigger EXECUTE IMMEDIATE ' CREATE TRIGGER TR01 BEFORE INSERT ON "TblX" BEGIN SET NEWROW.Action = NEWROW.Action + ''; Before Insert fired'' ; END; '; -- 2. INSERT a row EXECUTE IMMEDIATE 'INSERT INTO TblX(Action) VALUES(''Insert Row'')'; -- 3. Change trigger to BEFORE UPDATE EXECUTE IMMEDIATE ' ALTER TRIGGER TR01 BEFORE UPDATE ON "TblX" BEGIN SET NEWROW.Action = NEWROW.Action + ''; Before Update fired'' ; END; '; -- 4. UPDATE all rows EXECUTE IMMEDIATE 'UPDATE TblX SET Action = Action + ''; Update '' '; --> The BEFORE UPDATE didn't fire PREPARE SqlX FROM 'SELECT * FROM TblX'; OPEN CurX; END
This web page was last updated on Tuesday, April 23, 2024 at 08:39 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |