Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Able to connect and display .dbf data but not update
Message
From
26/02/2007 13:48:22
 
 
To
25/02/2007 04:13:39
Dave Nantais
Light speed database solutions
Ontario, Canada
General information
Forum:
ASP.NET
Category:
ADO.NET
Environment versions
Environment:
VB 8.0
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01198383
Message ID:
01198885
Views:
7
>This article only describes how to access Foxpro/XBase data not modify it.
>The article does not explain how to update/modify Foxpro/XBase data.

Not true. It describes populating the DA DeleteCommand,UpdateCommand and InsertCommand properties and using the DA.Update method.

> Futhermore, the article goes on to acknowledge the following :
>"As of the writing of this chapter, the Visual FoxPro OLE DB Provider does not work properly with the Command Builder. The Fox team was made aware of the problem, so there should hopefully be an updated version of the provider available by the time you read this."

I think this is correct and the CommandBuilder may still not generate accurate commands for the VFP OLEDB provider. But as Bonny says you can populate these yourself...

Regards,
Viv
Previous
Reply
Map
View

Click here to load this message in the networking platform