>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