>You could alter the SP to include the parameter as a returned column. Then VFP would see this as a memo field.
>e.g. (in sp)
>
select col1, col2, col3, @pFilterText as filterText from...
Thanks Trey,
We were considering doing just that.
But curiosity remains...
It must be something related to the VFP max for a string literal (which is 255), but I would expect (hope?) it would comply with the max character string or mvar length instead (16,777,184).
Do you (or anyone else) know why ODBC doesn't return the full string via the output parameter, instead of truncating it at 255?
Thanks again.