🚀 go-pugleaf

When using client-side cursor you should have primary key (or at least
unique index) on every table that is affected by update.

Client-side cursor changes record by executing

UPDATE ... SET ... WHERE ...

SQL command. If you have identical rows, all those rows will be updated.

----------------------------------------------------------------
Regards,
Viatcheslav V. Vassiliev
http://www.oledbdirect.com
The fastest way to access MS SQL Server, MS Jet (MS Access)
and Interbase (through OLEDB) databases.

"B Wilson" <bobknows@netzero.net> �������/�������� � �������� ���������:
news:3ed645c6@newsgroups.borland.com...
> Hello All,
>     I am writing a database program that uses Access.  In the tables I
> sometimes have records that are identical, which is done intentionally.
> However, when I try to modify one of those records, I am getting the
> following error "Key column information is insufficient or incorrect. Too
> many rows were affected by the update." I have builder 6 professional and
> access xp. What can I do to fix this problem?
>
> Bob
>
>