Subject | Re: [IBO] Generators and row selections |
---|---|
Author | Svein Erling Tysvær |
Post date | 2001-08-07T09:21:40Z |
Your trigger should be:
CREATE TRIGGER "SET_CUST_ID" FOR "CUSTOMERS"
ACTIVE BEFORE INSERT POSITION 0
AS
BEGIN
IF (NEW.CUST_ID IS NULL) THEN
NEW.CUST_ID = GEN_ID(CUST_ID_GEN, 1);
END
HTH,
Set
CREATE TRIGGER "SET_CUST_ID" FOR "CUSTOMERS"
ACTIVE BEFORE INSERT POSITION 0
AS
BEGIN
IF (NEW.CUST_ID IS NULL) THEN
NEW.CUST_ID = GEN_ID(CUST_ID_GEN, 1);
END
HTH,
Set