How can I map a NVChar field of SQL databse to a Richtext Box cont

[Land]

I have a SQL table with some NVChar fields, I wrote a Webservice and use that
webservice as the datasoure of Infopath. When I tring to map those NVChar
fields to Richtext Box controller, I found I can't simply right click the
normal Textbox controller generateb by Infopath and convert it to a Richtext
Box controoler, I can't mannually drag a Richtext Box controller to the page
and map it to NVChar field either. Is there any aritcle can give me some
examples about how to use Richtext Box Controller or Is there any suggestion?

Many thanks for your help!!

 

[Franck Dauché]

Hi,

Check this: http://www.infopathdev.com/forums/topic.asp?TOPIC_ID=106

Regards,

Franck Dauché

 

[Land]

I have checked the schema files extracted from XSN file and found XHTML field
difined like this:
<xsd:complexType mixed="true">
<xsd:sequence>
<xsd:any namespace="http://www.w3.org/1999/xhtml"
processContents="lax" minOccurs="0" maxOccurs="unbounded"/>
</xsd:sequence>
</xsd:complexType>
But when I use a Webservice as datasource. all NVChar field of SQL database
mapped to "string" type. I also can not change it through properity dialog in
Infopath becasue type choose field is gray.
I can manually extract schema files from XSN file and change "string" type
to "XHTML" type. But I don't think it's a good solution because there are
hundreds of NVChar fields mapped to "string" I need to modify and it's hard
to keep synchronicity with SQL database design.

Is there any good idea? Many appericiations for reply!