Maximum number of fields in VFP OLEDB update

Marcel Heitlager — Fri, 16 Dec 2016 08:16:06 GMT

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

RE: Maximum number of fields in VFP OLEDB update

Edhy Rijo — Fri, 16 Dec 2016 08:16:06 GMT

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

StrataFrame Forum » StrataFrame Application Framework - V1 » Business Objects and Data Access (How do I?) » Maximum number of fields in VFP OLEDB update

Maximum number of fields in VFP OLEDB update

RE: Maximum number of fields in VFP OLEDB update