>>Hello,
>>
>>Which field type and length is appropriate to use as VFP Memo field in MSSQL?
>>
>>I created fields with type "text" and Fieldlength = 2^31-1, but when I query from VFP it does not return the field value, it shows blank.
>>
>>In MySQL I used Mediumtext which works fine with memo fields.
>
>I used text and varchar(max). I can't understand why you couldn't use text.
Perhaps that is a driver problem, I use DRIVER=SQL Server Native Client 10.0.
When I create a varchar(max) field the type shows as text:
ALTER TABLE TestTable ADD NewField varchar(max)
SP_Columns TestTable
it shows:
Type_Name = "test"
Precision = 2147483647
A query from VFP with the above mentioned driver shows a completely blank field, which I cannot open.
When I copy to a table, it creates a character field with length 0!
Christian Isberner
Software Consultant