Subject | help please |
---|---|
Author | Daniel Bertin |
Post date | 2002-01-14T19:19:49Z |
Hi all, I'm stuck and confused again
I created a trigger from the script tab of IB_sql and it inserrted this
code in the trigger for the trk_plans table
TRIG_TRK_PLANS_BI (BEFORE INSERT)
AS BEGIN
IF(NEW."UKEY" IS NULL) THEN NEW."UKEY" = GEN_ID("GEN_TRK_PLANS_UKEY",1);
END
I have a generator GEN_TRK_PLANS_UKEY
When I do a insert into the table trk_plans and then try do do a post, I
get the error
EIB_datasetError "UKEY is a required field"
Do I need to activate the trigger in some way or the trigger is not coded
correctly?
What am I doing out of the ordinary, UKEY is the primary index
Help please again
Daniel
I created a trigger from the script tab of IB_sql and it inserrted this
code in the trigger for the trk_plans table
TRIG_TRK_PLANS_BI (BEFORE INSERT)
AS BEGIN
IF(NEW."UKEY" IS NULL) THEN NEW."UKEY" = GEN_ID("GEN_TRK_PLANS_UKEY",1);
END
I have a generator GEN_TRK_PLANS_UKEY
When I do a insert into the table trk_plans and then try do do a post, I
get the error
EIB_datasetError "UKEY is a required field"
Do I need to activate the trigger in some way or the trigger is not coded
correctly?
What am I doing out of the ordinary, UKEY is the primary index
Help please again
Daniel