>>>The problem is that if you use SQL Pass-Through, Varchar(max) fields comes over as blank fields.
>
>The dreaded C(0)? My experience is of Remote Views against Varbinary(max) into memo or memo binary type, which works fine (so far).
>
>For SPT I think SELECT CAST(MyVarcharMax AS Text) mttext should work, or with Text under threat of deprecation I think casting as varbinary(max) might get you somewhere.
>
>I'll raise this with Chen the VFP C++ Compiler author, since he might be able to explain varchar(max) to VFP's ODBC connection.
We have varchar(max) columns coming OK through SQL Pass-Through. I think there is a setting needed for this, though.
If it's not broken, fix it until it is.
My Blog