General

Re: Retrieve a RichText box data in the good format

nenemourinho — Tue, 20 Sep 2011 14:13:47 GMT

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

Re: Retrieve a RichText box data in the good format

Skarn — Sat, 17 Sep 2011 05:51:57 GMT

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.

Retrieve a RichText box data in the good format

nenemourinho — Tue, 13 Sep 2011 15:12:30 GMT

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)2]"

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)2] 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)2] instead of K[AU(CN)2]... 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