https://www.infopathdev.com:443/blogs/ernesto/archive/2010/10/27/mapping-rich-text-data-using-dbxl-v2-4.aspxDBXL v2.4 has recently been updated to add “String(InnerXml)” and “String(OuterXml)” in the DAT database mapping dropdowns. This allows you to map rich text data into SQL. We’ll illustrate the difference between InnerXml and OuterXml with two examplesenCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/blogs/ernesto/archive/2010/10/27/mapping-rich-text-data-using-dbxl-v2-4.aspx#66456Wed, 11 May 2011 14:13:55 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:66456ErnestoM<p>With code, it is a simple assignment of the richtext node to the string value returned from QueryDB (e.g. richTextNode.InnerXml = node.Value)</p> <img src="https://www.infopathdev.com:443/aggbug.aspx?PostID=66456" width="1" height="1">https://www.infopathdev.com:443/blogs/ernesto/archive/2010/10/27/mapping-rich-text-data-using-dbxl-v2-4.aspx#63456Mon, 24 Jan 2011 10:21:42 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:63456rgoel<p>Hi Ernesto,</p> <p>Based on your explanation about mapping RTF into SQL. </p> <p>How can we fetch rich text data from SQL which is in string inner xml form into Rich text box in Infopath 2007?</p> <p>Suppose we have another Infopath form where I need to show the SQL data which is in string inner xml.</p> <p>Please explain. It is urgent. We are analyzing the Qdabra2.4 trial software and we have requirement like this.</p> <img src="https://www.infopathdev.com:443/aggbug.aspx?PostID=63456" width="1" height="1">https://www.infopathdev.com:443/blogs/ernesto/archive/2010/10/27/mapping-rich-text-data-using-dbxl-v2-4.aspx#63302Tue, 18 Jan 2011 16:28:55 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:63302JMdream<p>Will this work only for InfoPath Rich Text fields? What if I wanted to map a Text box to SQL. I originally set up the data type in SQL as nvChar(MAX) and it was mapped in DAT as String. Do I need to drop an recreate my sql tables or just change my data type in DAT to String(inner), or must I also now also edit my form and change all text boxes to Rich Text fields too and can I keep mty SQL tables as is?</p> <img src="https://www.infopathdev.com:443/aggbug.aspx?PostID=63302" width="1" height="1">