Alexander,

I may be wrong, but I think the new VFP OLEDB driver addresses this string length limitation problem. I don't think we can download it as yet, but if you have installed the VFP7.0 beta, it should be available to you.

Sanjay

>>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