Subject | Re: Problem In BindingCursor |
---|---|
Author | Marco Menardi |
Post date | 2002-12-04T23:37:28Z |
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
"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
--- In IBObjects@y..., Sandeep Chandra <sandeep@c...> wrote:
> What does Problem In BindingCursor mean?
>
> I get this when I call Qry.InvalidateRowNum (RecNo).
>
> Regards
>
> Sandeep