Maximum number of fields in VFP OLEDB update


Author
Message
Marcel Heitlager
Marcel Heitlager
StrataFrame User (202 reputation)StrataFrame User (202 reputation)StrataFrame User (202 reputation)StrataFrame User (202 reputation)StrataFrame User (202 reputation)StrataFrame User (202 reputation)StrataFrame User (202 reputation)StrataFrame User (202 reputation)StrataFrame User (202 reputation)
Group: StrataFrame Users
Posts: 84, Visits: 835
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
GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...





Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search