PowerBuilder

Iterate over Direct Children with a Specific Tag

See more XML Examples

Demonstrates how to iterate over direct children having a specific tag.

The input XML, available at http://www.chilkatsoft.com/data/fruit.xml, is this:

<root>
    <fruit color="red">apple</fruit>
    <fruit color="green">pear</fruit>
    <veg color="orange">carrot</veg>
    <meat animal="cow">beef</meat>
    <xyz>
        <fruit color="blue">blueberry</fruit>
        <veg color="green">broccoli</veg>
    </xyz>
    <fruit color="purple">grape</fruit>
    <cheese color="yellow">cheddar</cheese>
</root>

PowerBuilder

integer li_rc
integer li_Success
oleobject loo_Xml
oleobject loo_Child
integer li_NumWithTag
integer i

li_Success = 0

loo_Xml = create oleobject
li_rc = loo_Xml.ConnectToNewObject("Chilkat.Xml")
if li_rc < 0 then
    destroy loo_Xml
    MessageBox("Error","Connecting to COM object failed")
    return
end if

// The sample input XML is available at http://www.chilkatsoft.com/data/fruit.xml
li_Success = loo_Xml.LoadXmlFile("fruit.xml")
if li_Success <> 1 then
    Write-Debug loo_Xml.LastErrorText
    destroy loo_Xml
    return
end if

//  Get the number of direct children having the tag "fruit"
li_NumWithTag = loo_Xml.NumChildrenHavingTag("fruit")

if li_NumWithTag > 0 then

    for i = 0 to li_NumWithTag - 1
        loo_Child = loo_Xml.GetNthChildWithTag("fruit",i)
        Write-Debug string(i) + ": " + loo_Child.Tag + " : " + loo_Child.Content
        destroy loo_Child
    next
    Write-Debug "-----"

    // Do the same as the above loop, but instead of creating
    // a new object instance for each child, call GetNthChildWithTag2 to
    // update the object's reference instead.
    for i = 0 to li_NumWithTag - 1
        // Navigate to the Nth child.  
        li_Success = loo_Xml.GetNthChildWithTag2("fruit",i)
        Write-Debug string(i) + ": " + loo_Xml.Tag + " : " + loo_Xml.Content
        // Navigate back up to the parent:
        li_Success = loo_Xml.GetParent2()
    next
    Write-Debug "-----"
end if



destroy loo_Xml