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