I hate this one. I've been bit by it before. In the connection column
properties, I had the key field set to computed. So even though the grid
would display the generator value, it was actually not inserting it into the
insert sql at all. In my trigger, I was inserting the generator value if the
key field is "null" or "0". So the key value displayed in the grid was one
less than the key value inserted into the grid due to the double indexing of
the generator.

Paul


""Paul Gallagher"" <paul@...> wrote in message
news:acjdj9$nt7$1@......

> Thanks. I guess I need to look at this closer. I am aware of the two
> situations you laid out, and I thought I had them covered, but apparently
> not.
>
> Paul
>
> ""Jason Wharton"" <jwharton@...> wrote in message
> news:013d01c20272$0839acc0$250312ac@CX170673E...
> > You have not supplied a primary key value in order for the client to

know

> > how to update the single record on the server. Either that or you have
> > altered the primary key on the server in triggers or something.
> >
> > Jason Wharton
> > CPS - Mesa AZ
> > http://www.ibobjects.com
> >
> >
> > ----- Original Message -----
> > From: "paultansit" <paul@...>
> > To: <IBObjects@yahoogroups.com>
> > Sent: Wednesday, May 22, 2002 5:22 PM
> > Subject: [IBO] Record not located
> >
> >
> > > Ok, I know this has been discussed a thousand times before.
> > >
> > > Here is the scenario with the transaction set to autocommit false:
> > >
> > > Insert a new record in a grid by arrowing down.
> > > Input the data.
> > > Arrow pack up to post.
> > > Arrow down again.
> > > Edit the data.
> > > Arrow back up and the "Record not located" error occurs.
> > >
> > > I guess this isn't really a problem and certainly not a bug, it's
> > > just the way it is. What I have done is to place a IB_Query.Refresh
> > > command on the OnPost event of the dataset. The refresh seems to
> > > resync everything and eliminate the error.
> > >
> > > I guess my question is, is this the right way of doing it? I don't
> > > see any real problem doing the refresh, but it does seem a little
> > > convoluted or redundant.
> > >
> > > Thanks,
> > > Paul
> >
> >
> >
> >
> >
>

___________________________________________________________________________

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