Dmitry,
Have you considered using a CDATA element to contain the multi-line text?
>Bonnie,
>Yes, you are correct, chr(10) was causing the problem. And I got good suggestions on how to remove chr(10) from the string. Then I ran into a limit of 255 char length when passing from .NET to VFP. So I decided to pass the data by saving an XML file on the drive and then loading this XML file on VFP side. So I am working on implementing this approach now.
>
>Thank you,
>
>>Dmitry,
>>
>>I see that you've posted several other threads about converting the chr(10) that was causing your problems here ... so can I assume that you've finally got an answer and everything's working ok now?
>>
>>~~Bonnie
>>
>>>Bonnie,
>>>I think you misunderstood my question. I don't have a dataset. I create XML string on-the-fly from TEXT properties of several textboxes. And I was having problem getting an error on sending the XML string to VFP over OleDb. The error was caused by chr(10) in the multiline textbox; that is, when user was typing in the multiline textbox. So far, the only way I found to get around the problem is to "remove" the CHR(10) from the string.
>>>But I don't know, yet, it this will cause a problem on the VFP side.
>>>
>>>Thank you for your input.
>>>
>>>>Dmitry,
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only