I'm with Daniel on this one. Try to install the latest MS SQL ODBC driver.
>Daniel,
>
>Thanks for the reply. I think the problem might be that our SQL column has
s and s, and I think VFP is recongnizing that as the end of the memo. Any clue on how to force a SQL field into a VFP memo field?
>
>thanks,
>
>>Frederick,
>>
>>What version of VFP/ODBC are you using? I don't see this behaviour with VFP6 and VFP7. Varchar fields <= 254 characters are represented as C(nnn) and varchar fields > 254 are converted to a memo in VFP.
>>
>>>I am using SQL Passthrough and am selecting a column which is a varchar on SQL. The SQL users are using it as a long memo, and when I get my VFP cursor, it is a 255 char field, so the field is truncated.
>>>
>>>Any ideas?
>>>
>>>Thanks in Advance...
--sb--