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.