General information
Category:
COM/DCOM and OLE Automation
>I get complaints that my select string is too long.
>Now I have a workaround that splits the query in two parts and updates the record in two passes.
>That is however not the right way I think.
>Do you know of such limitation?
Yes, it seems to be a VFP ODBC driver limitation near of 254 chars in string.
I just have tryed to pass a query string with length=260 and it fails.
ODBC trace shows that SQLExecDirect fails and query string passed correctly.
Qury string with length=254 works fine.
However I can't find any documentation about this limit, excluding article
"Q208208 - HOWTO: Add Records with Memo Data Using the Visual FoxPro ODBC Driver". It talking about 254 chars limit of string data with VFP ODBC driver.
I think somebody in Microsoft can explain this problem better.
HTH,
Alexander
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only