Oh wow, I didn't think of that.
Using a COMPUTED column attribute is a considerably risky thing to do it
appears.

This is why I so strongly recommend examining things in the SQL trace
monitor when things don't appear to be working as they should.

Regards,
Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com

----- Original Message -----
From: "Paul Gallagher" <paul@...>
Newsgroups: egroups.ibobjects
To: <IBObjects@yahoogroups.com>
Sent: Thursday, May 23, 2002 8:33 PM
Subject: Re: [IBO] Record not located


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