Hi,

I need to communicate with an old VFP database.
One table has more than 127 fields.  Anytime I do an update above that number of fields I get an error: "SQL: Too many fields in UPDATE."
The update is dynamically created by the business object (no stored procedures)
So is this a limitation of Strataframe, VFP OLEDB (9.0), or something else?  Is there a work around?  I wanted to use AllFieldNames but can't because of the error.

Thanks,

Marcel

Hi Marcel,

I don't know about this limitation, but make sure you have the latest Microsoft OLE DB Provider for Visual FoxPro 9.0 currently seems to be version 1.2

Edhy Rijo