Is there a place that enumerates the limits of the VFP oleDB driver. We are trying to use ADO >>> VFP OleDB >>> VFP tables. Our table has 84 fields in it. When we issue the ADORS.Update We generate a SQL statement to long error. Using ODBC tracing we see that the update is appx 1252 chars long so its not a '256' char limitation. When we reduce the field count to 80 fields the update succeeds.
So my question is where do I find the limits list. I tried searching MSDN, Knowledgebase etc...
Terry Rooks
Software Systems Architect
Microsoft Certified Solution Developer.Net
If at first you don't succeed, then skydiving definitely isn't for you.