| Subject | Re: [IBO] Wrong record after insert a record |
|---|---|
| Author | Artur Anjos |
| Post date | 2003-09-16T21:22:10Z |
Rui,
How can we get something from the server, if we don't know how to get it?
:-)
It does not need to be the primary key. You just inform IBO - using
KeyLinks - about the way you know to get the row. Maybe you have some fields
that togheter will unique-identify the row? Some other unique field that
it's not changed by some trigger.
What's the problem to create another field in your table just for this
purpose, and feed it with a generator? Row identifiers shouldn't have any
other use.
Artur
How can we get something from the server, if we don't know how to get it?
:-)
It does not need to be the primary key. You just inform IBO - using
KeyLinks - about the way you know to get the row. Maybe you have some fields
that togheter will unique-identify the row? Some other unique field that
it's not changed by some trigger.
What's the problem to create another field in your table just for this
purpose, and feed it with a generator? Row identifiers shouldn't have any
other use.
Artur
----- Original Message -----
From: "rui_alidata" <rui.batista@...>
To: <IBObjects@yahoogroups.com>
Sent: Tuesday, September 16, 2003 7:24 PM
Subject: Re: [IBO] Wrong record after insert a record
> Hi!
>
> The problem is I can't use a generator, because the number is not
> sequential. I must use a "trigger before insert" to calculate the
> primary key.
>
> Thanks,
>
> Rui Batista
>
> --- In IBObjects@yahoogroups.com, "Artur Anjos" <artur@a...> wrote:
> > Rui,
> >
> > You should create them in the client, before the trigger, so IBO
> can know
> > the value, and get the row usint it. Use property GeneratorLinks
> for that.
> >
> > Artur
> > (Very glad to see another portuguese on this list)
> >
> > ----- Original Message -----
> > From: "rui_alidata" <rui.batista@a...>
> > To: <IBObjects@yahoogroups.com>
> > Sent: Monday, September 15, 2003 5:57 PM
> > Subject: Re: [IBO] Wrong record after insert a record
> >
> >
> > > I'm creating the primary key in a trigger before insert.
> > > There are any way to solve this problem?
> > >
> > > Thanks,
> > >
> > > Rui Batista
>
>
>
>
___________________________________________________________________________
> 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/
>
>