InfoPath Dev

Dear all,

I'm fighting with a problem from a long time and I can't fix it...

I have a RichTextBox field in my formular, in this field I want to insert a formula example : K[AUCN₂]

I save the result in a SQL Database (nvarchar(200)). the result in SQL looks like this : "K[AU(CN)<sub xmlns=\"http://www.w3.org/1999/xhtml\">2</sub>]"

When I re-open my form and try to load my RichTextBox field by a Web service, (1 Rule to launch the query and 1 rule to set the field value) he put me K[AU(CN)<sub xmlns=\"http://www.w3.org/1999/xhtml\">2</sub>] in the RichTextBox Field instead of K[AUCN₂].

I've tried to pass the InnerXml of my field to another RichTextBox field and is not possible because the real value (in Code part) of my field is K[AU(CN)<sub xmlns=\\\"http://www.w3.org/1999/xhtml\\\">2</sub>] instead of K[AU(CN)<sub xmlns=\"http://www.w3.org/1999/xhtml\">2</sub>]... he triple the back slash and it's not possible to load it in a InnerXml...

If someone can help me, I really appreciate.

Thanks in advance,

 Nelson

I'm really not sure if this will help you as I have no experience in using Web services, but the linked template shows a jScript method of merging two rich text fields.

http://www.infopathdev.com/forums/storage/43/67007/joinRichTextFields.xsn

Maybe the logic can be used for your service?
It relies on the fact that rich text fields contain XHTML nodes which describe the rich content. I extract that content separately and manage it that way.

Dear Skarn,

Thanks a lot for your reply. Your solution isn't what I'm looking for. Clone the content of a RichTextBox to another I can do it. My problem is really due to the fact of transport RichTextBox content to SQL and retrieve it in a RichTextBox...

Best Regards