Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Data Adapter Wizard fails to generate code for vfp datab
Message
General information
Forum:
ASP.NET
Category:
The Mere Mortals .NET Framework
Miscellaneous
Thread ID:
00842222
Message ID:
00842532
Views:
19
Neil,

I wouldn't recommend doing this. There are differences in syntax and the classes that are involved. I would recommend doing them by hand.

>Hi Cathi,
>
>Thank you for responding. I have used the MM Jump Start to show me how to create a custom data access class. The Wizard generates all of the necessary code if I start with a connection to SQL Northwind. If I connect to vfp Northwind the Wizard fails to generate UPDATE and DELETE statements. Can I use the UPDATE and DELETE statements that have been generated for SQL Northwind as an example as to what is needed for vfp Northwind. Does vfp respond to the Wizard's generated SQL statements the same way as SQL does? Do the statements make sense to vfp?
>
>Thank you again,
>Neil
>
>
>>Neil,
>>
>>These are known issue with the VFP team. The real problem rests with the wizard itself. Hopefully it will be fixed in the next release of Visual Studio.
>>
>>>I was thinking about how I could get the schema of a fpw26 free table that the Data Adapter Configuration Wizard needs. Without the schema, we are limited in what the Data Adapter Configuration Wizard can produce in terms of UPDATE and DELETE statements.
>>>
>>>This is what I came up with:
>>>
>>>1)Create a dummy dbc
>>>2)Make a copy of the free table, along with fpt and cdx files, that I need the schema to.
>>>3)Add the the copy of the free table to Dummy.dbc
>>>4)Have the Wizard work off of Dummy.dbc and then modify the generated code afterwards so that the code will work with the actual free table.
>>>
>>>So, this is what happened:
>>>I made a dummy dbc and added the copy of the free table to Dummy.dbc. I marked one of my index tags as primary. I created a class called DummyDataAccess and dragged over OleDbDataAdapter from the toolkit. The Wizard fired up and I selected Dummy.dbc as the data connection. The query buider had my table in it's list so I new I was making progress. The problem is that I still cannot get the wizard to generate Update and Delete statements. The error noted by the wizard is extremely vague, namely:
>>>"There were errors configuring the data adapater". So I cannot even get the Wizard to work off of a vfp database. Has anyone got the wizard to work off of a vfp database? I even attempted top use the wizard with the vfp version of Northwind, thinking that my database was screwy, and got the same error. So, does the Wizard work with vfp data yet or so we still have to wait for the next update?
>>>
>>>Any thoughts? Any body?
>>>Neil
-----------------------------------------

Cathi Gero, CPA
Prenia Software & Consulting Services
Microsoft C# / .NET MVP
Mere Mortals for .NET MVP
cgero@prenia.com
www.prenia.com
Weblog: blogs.prenia.com/cathi
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform