Have checked the table. It definitely has a primary key (of four columns),
and the columns concerned are listed in both Index Fields and KeyKinks
properties.

The setkey/gotokey performs exactly as expected and finds the correct record
which is displayed in the DB-aware components. It is only when the update
portion of the navigate bar(BDE) is pressed that the error occurs.

However, there seems to be some problem in the table. Both IBAccess and
IBQuery blow-up when attempting to select * from the whole table. Oddly,
Borland's DBExplorer doesn't blow-up. I have traced the problem to certain
entries in a varchar(80) column - containing the character £ (English
currency sign).

Might this be a cause of problem in my app, and if so, how do you suggest I
deal with it?

Neville Richards

----- Original Message -----
From: "Jason Wharton" <jwharton@...>
To: <IBObjects@yahoogroups.com>
Sent: Monday, March 31, 2003 11:23 PM
Subject: Re: [IBO] Problem in BindingCursor


> You probably don't have a primary key for a table and it is using the
DBKey
> by default.
>
> Jason Wharton
> CPS - Computer Programming Solutions
> Mesa Arizona
> http://www.ibobjects.com
>
> -- We may not have it all together --
> -- But together we have it all --
>
> ----- Original Message -----
> From: "nevillerichards" <neville@...>
> To: <IBObjects@yahoogroups.com>
> Sent: Monday, March 31, 2003 12:05 PM
> Subject: [IBO] Problem in BindingCursor
>
>
> > I have an App nearly complete (converted from BDE), and am having
trouble
> with the last little bit.
> >
> > At the bottom of a drill-down, I need to edit records. Form type
display
> is using an IBOTable through a DataSource to DB-aware controls. Record
> found by setkey/gotokey. Use of navigate bar causes the: 'Problem in
> BindingCursor' error.
> >
> > I have lashed-up a simple DBGrid through the same sort of arrangement
just
> on its own, and will edit the table (from the grid) just fine. The table
> does have a primary key spanning FOUR columns.
> >
> > Is there a set of known conditions (or omissions) which leads to the
error
> message? I've tried all the things I can think of.
> >
> > Neville Richards
> >
>
>
>
>
___________________________________________________________________________
> 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/
>
>
>