Tim,
It sounds like you are getting Unicode which means you get a Chr(0) separating your characters. You can convert this back to a normal string using the StrConv function.
cnormalvar = strconv(strconv(cunicodevar,6),2)
HTH.
>Hi all,
>
>I am experimenting with the cursor adapter and using Mark's cabuilder program have build a set of classes to use with one of my apps. I am experiencing a problemwhereby I access a SQL Server table containing a nvarchar field and return values to a form with an editbox control.
>
>When the cursor is created as a memo type of field, each character is seperated by a square in the display. It is almost like it was getting a line feed or some odd character in there. If I change the data type from nvarchar to varchar, it all works as it should.
>
>Is there anyway to render the cursor and editbox properly?
>
>Thanks,
>
>Tim Hayes
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao