Hi, Michel.
>I have an XML which has the following on top for the schema:
>
>
><xs:element name="motpasse" type="xs:base64Binary" minOccurs="0" />
><xs:element name="prenom" type="xs:string" minOccurs="0" />
>
>
>If I do a simple XMLToCursor(), such as:
>
>
>XMLTOCURSOR(FILETOSTR('d:\a.xml'),'Temp')
>
>
>The related fields for that schema attributes would be returned as memo fields. How can I have those converted to Character Binary and Character fields by the use of XMLToCursor()?
AFAIK, you can't with XmltoCursor(), but you can make some manipulation with an XmlAdapter. Basically, once you called the LoadXml and read it, you can access the XmlFields collection for the proper XmlTable (if you have more than one), and then change the data types.
Hope this helps,