Subject | Re: [IBO] help please |
---|---|
Author | Daniel Bertin |
Post date | 2002-01-14T19:38:22Z |
Thanks
I do get that error also in IB_SQL data tab? when I do an insert ,
shouldn't the trigger take care of this?
At 08:30 PM 14/01/2002 +0100, you wrote:
I do get that error also in IB_SQL data tab? when I do an insert ,
shouldn't the trigger take care of this?
At 08:30 PM 14/01/2002 +0100, you wrote:
>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/
> >
> >
> >
>
>
>
>
>___________________________________________________________________________
>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/