There's a flag in CursorToXML() to wrap memo fields into CDATA tag
>I used CursorToXML() to convert a FoxPro cursor to an XML file. That part worked fine, and it generated what looks like a good XML file to me.
>
>CursorToXML('gfse_searchresults','c:\temp\001.xml',1,512,0)
>
>However, when I try to use XmlToCur() on this XML file to read it back into a cursor, it complains about an invalid character.
>
>XMLToCursor("c:\temp\001.xml", "test",512)
>
>Error: XML Parser error: An invalid character was found in text content. Line 143, Position 15. _memberdata =
>
>I know that one of the fields in my original cursor is a memo field which contains FoxPro code with a reference to the _memberdata property of a form, which is XML already, so it appears that this is causing the XmlToCursor() to fail.
>
>
><?xml version = "1.0" encoding="Windows-1252" standalone="yes"?>
><VFPData>
> <gfse_searchresults>
> <process>false</process>
> <filepath>h:\work\lm5\classes\menu.vcx</filepath>
> <filename>menu.vcx</filename>
> <trimmedmatchline>cpartcountsource A string that will be Eval'd to get the Qty of the current Part.</trimmedmatchline>
> <baseclass>grid</baseclass>
> <parentclass>menugrid</parentclass>
> <class>gridpartmtlitems</class>
> <name>cpartcountsource</name>
> <methodname/>
> <containingclass/>
> <classloc>menu.vcx</classloc>
> <matchtype><<Property Def>></matchtype>
> <timestamp>2014-12-17T17:29:32</timestamp>
> <filetype>VCX</filetype>
> <type/>
> <recno>588</recno>
> <procstart>0</procstart>
> <matchstart>12</matchstart>
> <matchlen>82</matchlen>
> <listext>false</listext>
> <column>RESERVED3</column>
> <code>npartcount
>cpartcountsource A string that will be Eval'd to get the Qty of the current Part.
></code>
> <id>9</id>
> <matchline>cpartcountsource A string that will be Eval'd to get the Qty of the current Part.
></matchline>
> <replaced>false</replaced>
> <trimmedreplaceline/>
> <replaceline/>
> <replacerisk>3</replacerisk>
> <replace_dt/>
> </gfse_searchresults>
></VFPData>
>
>
>
>
>.
--sb--
