Subject | Re: [IBO] help please |
---|---|
Author | Luiz Alves |
Post date | 2002-01-14T19:32:38Z |
Daniel,
There is a property called GeneratorLinks in tib_XXX native ibo querys and
tibo_XXX dataset derived components.
Fill it with:
UKEY=GEN_TRK_PLANS_UKEY
Luiz.
There is a property called GeneratorLinks in tib_XXX native ibo querys and
tibo_XXX dataset derived components.
Fill it with:
UKEY=GEN_TRK_PLANS_UKEY
Luiz.
----- Original Message -----
From: "Daniel Bertin" <daniel@...>
To: <IBObjects@yahoogroups.com>
Sent: Monday, January 14, 2002 5:19 PM
Subject: [IBO] help please
> 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