Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Problems Saving to Foxpro Database
Message
General information
Forum:
ASP.NET
Category:
The Mere Mortals .NET Framework
Environment versions
Environment:
C# 2.0
OS:
Windows XP SP2
Network:
Windows 2000 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01175006
Message ID:
01175450
Views:
6
Davem

>I'm having problems with saving data to Foxpro Data from an ASP .NET form. The data is being read properly and is getting bound to textboxes, etc. But when I call the this.Save(...) method, I get the following error:
>
>OleDbCommand.Prepare method requires all parameters to have an explicitly set type.
>
>I've tried the SaveRow() method as well but got the same results. I did use the MM business layer generator to create the entities to bind to the textboxes, etc.
>
>I then tried the MM winform sample with the orders form and I get the same error when I attempt to save any changes there, too.
>
>I tried to follow the code down in the MM framework, but could not locate where the commands were being established for the Prepare method to work with to see if I could detect what might be going on.
>
>When I examine the dataset in debug mode, I do see date fields expressed with both the date and time but the Foxpro fields are only of the date type.
>
>I seem to be missing the boat here on something. Any suggestions?

Are you using the latest VFP OLEDB provider that shipped with VFP 9? To test if all is well on your machine, you can try using the MM .NET Windows Forms sample application to see if that works properly. To get the sample application to use VFP data, after the application starts up, go to the File | Options..., then under Database Sets select "Customer B (Visual FoxPro)", then click OK.

Best 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