>>>>Here is what I see in afields for this field, what do you think?
>>>
>>>
>>>
>>>Well, I checked the help - yours must be missing - and the field ( see lafields[1, 6] ) does codepage translation, it should be true
>>>
>>In other words, can I change it to .T. after I already got the data from SQL Server?
>
>
>Set nocptrans to ...
>
>
>Nah - I was wrong, it IS binary since the field type in your afields is Q.
>
>And, I do not think it matters, since you are not using a vfp textbox control
>
>
>Would have tested it this afternoon - but I do not see the ms forms text control in the installed ActiveX - do not know why
I believe this control comes with MS Word. See this article
http://msdn.microsoft.com/en-us/library/aa140269(office.10).aspxI also see this
http://www.foxite.com/archives/how-to-implement-unicode-in-vfp-0000209431.htm but it only talks about showing the data, not how to save the data.
If it's not broken, fix it until it is.
My Blog