>I have no problem with that. The problem is the fact that this
>is a remote view (did I forget to mention this earlier?) into
>a MS SQL Server 6.0 table. In SQL Server, it's a
text datatype. Under FoxPro, well, I don't really know how FoxPro
>handles MS SQL Serer
text fields.
sorry i must have mis-read ur msg
anyway, a couple of things that come to mind
- try setting the "use memo for fields >=" to a lower value (under remote data in the option dialog)
- check with MS if the ODBC driver you use is the latest version
HTH
Arnon