🚀 go-pugleaf

Server-side cursor may be read-only - it is allowed by OLEDB specification
and depends on OLEDB provider. On MS SQL Server server-side cursor is
read-only if there is no primary key.

Client-side cursor does updates by executing SQL query such as:

UPDATE tablename SET colX = .... WHERE ...

To correctly implement WHERE primary key should present, otherwise it is
possible that row can not be located or WHERE points to some rows instead of
one.

Anyway it is very good idea to add primary key to every table.

//------------------------------------------
Regards,
Vassiliev V. V.
http://www.managed-vcl.com - using .Net objects in Delphi for Win32 +
ADO.Net
http://www.oledbdirect.com - The fastest way to access MS SQL Server,
MS Jet (Access) and Interbase (through OLEDB)

"Orlando Lopez" <hlopezrd@hotmail.com.do> �������/�������� � ��������
���������: news:41012168@newsgroups.borland.com...
>
> Hi to all,
>
> I'm trying to use CFP OleDB Provider to access (and modify)
> VFP 6 tables. I tried to use odbc, but is very slow, so I'm
> trying to use OLEDB Provider (from microsoft) for VFP.
>
> Everything work fine, except that when I do a refresh to a table
> I got an error message:
> "Insufficient key column information for updating or refreshing"
> (the tables don't have index or primary key)
>
> Reading some info from Microsoft web site, I found that that can
> be fixed if I change the CursorLocation property to clUseServer,
> and that fix the problem of doing refresh, but that modify the
> readonly property to true, and I don't know why.
> Is a bug? or I'm doing some wrong?
>
>
> Orlando.