Vlad, thanks for your help, but it's not as useful as We would like to be.

If I use a memo field, VFP returns an error 1543 "the conversion required ...".

There are an interesting article, "Comparing VFP and SQL Server 7.0 Datatypes" by Michael Levy in the MSDN Library that talk about this question.

This article talks about something like that: I could try to set UseMemoSize property to something less than 254 and the data type to Char greater than the MemoSize. In this way, VFP will maps the field to Memo, but it doesn't work.

I don't know if it could be a ODBC version problem.

Kind regards.


>Use memo field for this. You may map fields to any type using properties window for fields in view designer.
> In addition, when you want automatically use memo fields, on the SQL server use 'text' field type to store text.
>

>>Hi,
>>
>>I´m trying to mapping an ntext field in SQL-Server 7.0 from VFP 6.0 Remote View, but I can't read and write more than 254 bytes.
>>
>>Can anybody help me?
>>
>>Thanks.