Daniel,

have a look on the GeneratorLinks property.

In your example set the GeneratorLinks property as follows:

UKEY=GEN_TRK_PLANS_UKEY

HTH,
Thomas Steinmaurer
IB LogManager 2.0 - The Logging Tool for Interbase/Firebird
http://www.iblogmanager.com

"Daniel Bertin" <daniel@...> schrieb im Newsbeitrag
news:5.1.0.14.0.20020114110602.01c58af8@mustang...

> 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
>
>
>
>

___________________________________________________________________________

> IB Objects - direct, complete, custom connectivity to Firebird or

InterBase

> without the need for BDE, ODBC or any other layer.
>

___________________________________________________________________________

> http://www.ibobjects.com - your IBO community resource for Tech Info

papers,

> keyword-searchable FAQ, community code contributions and more !
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>