Maximum number of fields in VFP OLEDB update


Author
Message
Marcel Heitlager
Marcel Heitlager
StrataFrame User (180 reputation)StrataFrame User (180 reputation)StrataFrame User (180 reputation)StrataFrame User (180 reputation)StrataFrame User (180 reputation)StrataFrame User (180 reputation)StrataFrame User (180 reputation)StrataFrame User (180 reputation)StrataFrame User (180 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
Edhy Rijo
E
StrataFrame VIP (4.5K reputation)StrataFrame VIP (4.5K reputation)StrataFrame VIP (4.5K reputation)StrataFrame VIP (4.5K reputation)StrataFrame VIP (4.5K reputation)StrataFrame VIP (4.5K reputation)StrataFrame VIP (4.5K reputation)StrataFrame VIP (4.5K reputation)StrataFrame VIP (4.5K reputation)
Group: StrataFrame Users
Posts: 2.4K, Visits: 23K
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

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