General information
Category:
The Mere Mortals .NET Framework
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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only