On Thu, 2002-12-05 at 12:37, Marco Menardi wrote:

> I think that it means that IBO can't locate the row when it tries to
> "refresh" it, because it has no unique information to get it.
> i.e. if in your query you have a join, you could have in the dataset 5
> identical records. If you are on the 4° record, and want to refresh
> it, IBO can't tell the server "give me THAT record", since it has no
> unique key to provide to the server...
> If you work with Paradox/DBase/Access databases, you have "record
> number" that is always unique, while with client/server you don't have.
> The "uniqueness" of a row is given bu it's primary key, and the
> uniqueness of a join is incertain. If you have to work that way on a
> join, you have to include fields that can produce an unique value, and
> tell IBO using the KeyLinks property.
> In query without Joins, IBO with "KeyLinksAutodefine" usually can
> produce a unique "key" automatically, but if not, you have to provide
> it by hand.
> regards
> Marco Menardi

Thank you very much. That helped a lot. Now I can Refresh one row. I had
a query with joins and that's why it was not working.

Regards

Sandeep