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