>>>>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 was thinking I may try to create a cursor in advance with the M nocptrans and append from the cursor from SQL Server.
I actually didn't see MS EditBox which is mentioned in Rick's article, so I found MS Forms2 Textbox in the list of ActiveX I have.
I also have a recollection I read an article before about this control and unicode, but quick Google search turned fruitless, so I don't know.
If it's not broken, fix it until it is.
My Blog