(PowerBuilder) XML Sort Records by Content

Demonstrates the SortRecordsByContent method.

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

<root>
    <fruits>
        <fruit>
            <name>apple</name>
            <color>red</color>
        </fruit>
        <fruit>
            <name>banana</name>
            <color>yellow</color>
        </fruit>
        <fruit>
            <name>blackberry</name>
            <color>purple</color>
        </fruit>
        <fruit>
            <name>blueberry</name>
            <color>blue</color>
        </fruit>
        <fruit>
            <name>orange</name>
            <color>orange</color>
        </fruit>
        <fruit>
            <name>pear</name>
            <color>green</color>
        </fruit>
    </fruits>
</root>

Chilkat ActiveX Downloads ActiveX for 32-bit and 64-bit Windows

integer li_rc
oleobject loo_Xml
oleobject loo_XSortRoot
integer li_Success
integer li_BAscending

loo_Xml = create oleobject
// Use "Chilkat_9_5_0.Xml" for versions of Chilkat < 10.0.0
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/fruitRecordsSort.xml
li_Success = loo_Xml.LoadXmlFile("fruitRecordsSort.xml")
if li_Success <> 1 then
    Write-Debug loo_Xml.LastErrorText
    destroy loo_Xml
    return
end if

// The "fruit" records are direct children of the "fruits" node.
// Therefore, to sort the fruit records, the SortRecordsByContent
// method must be called from the "fruits" node.
loo_XSortRoot = loo_Xml.FindChild("fruits")

// Sort by the "name" field in ascending order.
li_BAscending = 1
loo_XSortRoot.SortRecordsByContent("name",li_BAscending)

// Show the result:
Write-Debug loo_Xml.GetXml()

// <root>
//     <fruits>
//         <fruit>
//             <name>apple</name>
//             <color>red</color>
//         </fruit>
//         <fruit>
//             <name>banana</name>
//             <color>yellow</color>
//         </fruit>
//         <fruit>
//             <name>blackberry</name>
//             <color>purple</color>
//         </fruit>
//         <fruit>
//             <name>blueberry</name>
//             <color>blue</color>
//         </fruit>
//         <fruit>
//             <name>orange</name>
//             <color>orange</color>
//         </fruit>
//         <fruit>
//             <name>pear</name>
//             <color>green</color>
//         </fruit>
//     </fruits>
// </root>

destroy loo_XSortRoot


destroy loo_Xml