>>>><?xml version="1.0" encoding="utf-8" ?> >>>>- <Report p1:schemaLocation="PayRegExtract http://99.99.9.999/ReportServer?%2fTotalCompensation%2fPayRegExtract&rs% >>>>3aCommand=Render&rs%3aFormat=XML&rs%3aSessionID=eo4karztrbozd545bjfj0orz&rc%3aSchema=True" >>>>Name="PayRegExtract" xmlns:p1="http://www.w3.org/2001/XMLSchema-instance" xmlns="PayRegExtract"> >>>>- <table1> >>>>- <Detail_Collection> >>>> <Detail PP ...... >>>> <Detail PP ...... >>>> <Detail PP ...... >>>> </Detail_Collection> >>>> </table1> >>>></Report> >>>>>>>>
>>>>- <Report p1:schemaLocation="PayRegExtract http://99.99.9.999/ReportServer?%2fTotalCompensation%2fPayRegExtract&rs% >>>>3aCommand=Render&rs%3aFormat=XML&rs%3aSessionID=eo4karztrbozd545bjfj0orz&rc%3aSchema=True" >>>>Name="PayRegExtract" xmlns:p1="http://www.w3.org/2001/XMLSchema-instance" xmlns="PayRegExtract"> >>>>>>>>
>>>></Report>
>>>>
>>>>>>>lnLines = ALINES(laXML, FILETOSTR("your file with full path to it.XML") >>>FOR lnFor = 1 TO lnLines >>> ? laXML[lnFor] >>>NEXT >>>>>>But why you need to remove something in it?
>>LOCAL oxml as XMLAdapter >>oxml = NEWOBJECT("xmladapter") >>oxml.LoadXML("C:\test2\PayRegExtract.xml") >>>>
>>XML Error: XML Parse error: Invalid at top level of the document. >>Line 1, Position 1 C:\test\PayRegExtract.xml >>>>
>>SELECT * from xfer_payroll INTO CURSOR crsparse readwrite >>SELECT crsparse >>XMLTOCURSOR("C:\test2\PayRegExtract.xml","crsparse",512) >>browse >>>>
>><?xml version="1.0"?> >><table1> >> <Detail_Collection> >> <Detail PP=" >>... >>... >> </Detail_Collection> >></table1> >>>>