Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Saving Data to fpw26 free tables
Message
General information
Forum:
ASP.NET
Category:
The Mere Mortals .NET Framework
Miscellaneous
Thread ID:
00841192
Message ID:
00841502
Views:
21
Neil,

>The problem is that when I use free fpw26 tables in the same example, I receive the following error. And... it does not look good for saving data back to free tables. Any suggestions? Do I have to create a Custom Data Access Class?

It looks like you're running into the limitation with the VFP OLE DB provider mentioned in the Dev Guide topic "Does the VFP OLE DB Provider work with free tables?":

The Visual FoxPro OLE DB Provider works with both database and free FoxPro tables (including FoxPro 2.6 tables), however support is limited where there is no database container. ADO.NET cannot retrieve sufficient schema information such as the primary key required for the Command Builder for many automatic operations. This means you need to create custom data access classes when working with free tables (see the Help topic Creating Custom Data Access Classes for details). In addition, depending on file locations it may be necessary to specifically path operations (for example: Update c:\data\customers).

Regards,
Kevin McNeish
Eight-Time .NET MVP
VFP and iOS Author, Speaker & Trainer
Oak Leaf Enterprises, Inc.
Chief Architect, MM Framework
http://www.oakleafsd.com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform