Can an insert trigger cause an update trigger to be fired also? My
triggers are listed below. I want tgr_on_insert to fire tgr_on_update.
------------------------------------------------------------------------
------------------------------------------------------------------------
------
CREATE TRIGGER tgr_on_insert AFTER INSERT ON table
BEGIN
UPDATE table SET flag = 1 where column1 = NEW.column1 AND
column2 = NEW.column2;
END;
------------------------------------------------------------------------
------------------------------------------------------------------------
------
CREATE TRIGGER tgr_on_update AFTER UPDATE OF flag ON table
BEGIN
UPDATE table SET flag = 1 where time < NEW.time and flag =
0;
END;
------------------------------------------------------------------------
------------------------------------------------------------------------
------
Please note that the update trigger is set for updates on the flag
field, but I want to run the update code if there are records with a
time < the time of the updated record and the flag = 0. This will only
happen if the original insert trigger does not update the flag field.
Nathan Biggs
Computerway Food Systems
(336) 841-7289
