>I have one XML file. Can you help me take a look?
>Actually I don't know it is standard XML file or not?
>How can i attachment a file and send it to you?
The XML string is built manually. It's not something created with CURSORTOXML() from the server side. So, you will have to extract the data by the use of the DOM object. For example:
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 lcValue
is a function you can use to extract a specific node.
This XML contains the parent record and two child records, in this case. So, you just have to implement some logic such as described above and you'll be ok.