><?xml version="1.0"?> ><root xmlns:dt="urn:schemas-microsoft-com:datatypes" > ><application> > <id dt:dt="number">3</id> > <acronym>ABC</acronym> > <version dt:dt="number">6.3</version> > <name>American Broadcasting Corporation</name> > <status>Development</status> > <PAC-status>N/A</PAC-status> > <department>Sales</department> ></application> ></root> >I tried several combinations and I can't. This XML is created from another development environment, and the way it is created, can't be handled by VFP's XMLTOCURSOR(). Unless someone comes up with a magic solution, you will have to use the DOM object() for that such as:
* Return a specific XML node value * expC1 XML content * expC2 Node localization FUNCTION GetXMLValue PARAMETERS tcXML,tcNode LOCAL lcValue,loXML,loNode lcValue='' loXML=CREATEOBJECT('MSXML.DOMDocument') loXML.LoadXML(tcXML) loNode=loXML.SelectSingleNode(tcNode) lcValue=loNode.GetAttribute('Value') RETURN lcValueso to parse it manually and create the cursor by yourself.