| Subject | Cannot create simple trigger??? |
|---|---|
| Author | dleec45 |
| Post date | 2004-05-23T06:24:52Z |
I'm trying to crate some simple triggers and am getting an error that
appears that GEN_ID is not recognized. Here's the trigger:
SET TERM !! ;
CREATE TRIGGER Trg_Address_ID
FOR Address
BEFORE INSERT AS
NEW.ID GEN_ID(addr_gen_id, 1);
END !!
SET TERM ; !!
and it blows up on GEN_ID!! Isn't this the correct format?
appears that GEN_ID is not recognized. Here's the trigger:
SET TERM !! ;
CREATE TRIGGER Trg_Address_ID
FOR Address
BEFORE INSERT AS
NEW.ID GEN_ID(addr_gen_id, 1);
END !!
SET TERM ; !!
and it blows up on GEN_ID!! Isn't this the correct format?