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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Land - 08 Nov 2005 03:32 GMT

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!!

Reply to this Message

Franck Dauché - 08 Nov 2005 03:55 GMT

Hi,

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

Regards,

Franck Dauché

> 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
[quoted text clipped - 5 lines]
>
> Many thanks for your help!!

Reply to this Message

Land - 17 Nov 2005 06:26 GMT

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!

> Hi,
>
[quoted text clipped - 13 lines]
> >
> > Many thanks for your help!!

Reply to this Message