Hi,
If you have time to complete the code it would be very helpful
Andy
>Hi, Andy.
>
>>>To do this now you have to resort to manually process your XML (using the MsXml parser). It is planned for Europa (next VFP version) to support that kind of XML hierarchies, although it hasn't being explained -AFAIK- how it owuld be implemented.
>
>>Any suggestions on how best to do that?
>
>Well, to generate the XML maybe you can skip the parser altogether and manually build the XML.
>
>You can do something as primitive as:
>
>
>set textmerge to sample.xml noshow
>
>\\< ?xml version="1.0" encoding="windows-1252"?>
>\< AndyTable>
>
>select Header
>scan
> GenerateHeaderElements()
>
> select Detail
> scan for Detail.ParentID = Header.id
> GenerateDetailElements()
> endscan
>endscan
>
>\< /AndyTable>
>set textmerge to
>
>
>The two GenerateXYZElements should scan the table fields and build the < field>content< /field> tags for the given record.
>
>Let me know if you need more help and I'll try to complete the sample.
>
>See you,