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,
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham