Hi All I have a script that creates my database structure. I create the following trigger for a table but unlike my other triggers this one is created 'inactive'. I can run 'ALTER TRIGGER FilterStore_Inc ACTIVE' and activate the trigger without issue. The table and sequence are already created in the DB before the trigger is created.
CREATE OR ALTER TRIGGER FilterStore_Inc FOR FilterStore ACTIVE BEFORE INSERT POSITION 0 AS BEGIN IF (NEW.FilterStoreRef IS NULL) THEN BEGIN NEW.FilterStoreRef = GEN_ID(FilterStoreRef_Seq, 1); END END^ Any idea why this might be? Thanks Rob
