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...
Frederick Kusin NetBase Development Group 3746 Folsom Street San Francisco, CA. 94110 www.netbasegroup.com