By Marcel Heitlager - 12/14/2016
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
|
By Edhy Rijo - 12/16/2016
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
|
|