This is actually a bug in VS.NET and is being addressed in the next release.
>Thats a known bug, even the latest vfpoledb doesn't solve this. May be the next version 9,would solve it.
>
>Workaround , dont auto generate the dataset, create your own select,update,delete statements.
>
>HTH
>
>>If I drag and drop a SQL table to a web form I get a connection and adapter created. Nice!
>>
>>If I drag a Visual Foxpro table to a web form or a table from the IBM AS/400 I get an error message: "The wizard detected the following problems when configuring the data adapter for "mytable". Details: Generated SELECT statement. There were errors configuring the data adapter."
>>Not Good!
>>
>>I have tried the following providers and I get the error message for all of them:
>>Microsoft OLE DB Simple Provider
>>Microsoft OLE DB Provider for Visual FoxPro
>>Microsoft OLE DB Provider for ODBC Drivers
>>
>>Any suggestions? Thank you in advance.
-----------------------------------------
Cathi Gero, CPA
Prenia Software & Consulting Services
Microsoft C# / .NET MVP
Mere Mortals for .NET MVP
cgero@prenia.comwww.prenia.comWeblog: blogs.prenia.com/cathi