Write a SP to do this it seems too much work for a too small problem.

I will use GeneratorLinks, after all, u create this facility for this
propose, uh? So, let's use it.

Thanks and []
Andrei

2005/12/7, Jason Wharton <jwharton@...>:

> If you want to do this without using GeneratorLinks you would have to write
> a stored procedure that does the insert for you and have it also return the
> columns with new values in return parameters, which IBO picks up and takes
> into consideration for you.
>
> Using GeneratorLinks is my recommendation.
>
> Jason Wharton
>
>
> > -----Original Message-----
> > From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com]On
> > Behalf Of Andrei Luís
> > Sent: Wednesday, December 07, 2005 11:30 AM
> > To: IBObjects@yahoogroups.com
> > Subject: Re: [IBO] Re: How to use bookmarks like tTable and tQuery?
> >
> >
> > Thomas,
> >
> > I altered the trigger like u said, and set registro_id as not required
> > in IB_Query. The same behavior: After post, the pointer is at the
> > record it was before the insert comand.
> >
> > I forgot to mention: Now I'm using generatorLinks property instead
> > trigger, and it's working like I need.
> >
> > []
> > Andrei
> >
> > 2005/12/7, Andrei Luís <compuvale.software@...>:
> > > Is there any problem to use the trigger like I posted?
> > Because it's a
> > > trigger only or Before Insert event...
> > >
> > > I tried to use triggers like u said when I was learning
> > about Firebird
> > > + IBO, but, I was getting error messages in Delphi like "Registro_id
> > > is a required field and cannot be null", and so I suppres "IF
> > > (NEW.REGISTRO_ID IS NULL) THEN" and set registro_id to receive 0
> > > (zero) as default value in IBO.
> > >
> > > After I changed all my triggers and code like this, I heard about
> > > setting registro_id field to a not required field, but, sincerely, I
> > > didn't do any change...
> > >
> > > I will test and put the result here.
> > >
> > > []
> > > Andrei
> > >
>