VFP OLEDB Provier Bug?

Article View: borland.public.cppbuilder.database.ado

Article #1344

Back to borland.public.cppbuilder.database.ado Previous Next

#1344

From: Orlando Lopez
Date: Fri, 23 Jul 2004 14:32

20 lines
1483 bytes

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.

Technical Details

Message-ID: <41012168@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!fu-berlin.de!newsfeed.iinet.net.au!newsfeed.iinet.net.au!PeerFeed.KWeb.on.ca!news.kweb.on.ca!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Thread: 10698b,79e952bb33042916,start
X-Google-Attributes: gid10698b,public
X-Google-Language: ENGLISH,ASCII-7-bit
From: "Orlando Lopez" <hlopezrd@hotmail.com.do>
Sender: "Orlando Lopez" <hlopezrd@hotmail.com.do>
Reply-To: "Orlando Lopez" <hlopezrd@hotmail.com.do>
Subject: VFP OLEDB Provier Bug?
Newsgroups: borland.public.cppbuilder.database.ado
X-User-Info: 200.42.216.126     
NNTP-Posting-Host: 207.105.83.66
Message-ID: <41012168@newsgroups.borland.com>
Date: 23 Jul 2004 07:32:08 -0700
X-Trace: newsgroups.borland.com 1090593128 207.105.83.66 (23 Jul 2004 07:32:08 -0700)
Lines: 20
Path: arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!fu-berlin.de!newsfeed.iinet.net.au!newsfeed.iinet.net.au!PeerFeed.KWeb.on.ca!news.kweb.on.ca!newsgroups.borland.com!not-for-mail