(DataFlex) 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

Use ChilkatAx-win32.pkg

Procedure Test
    Handle hoXml
    Variant vXSortRoot
    Handle hoXSortRoot
    Boolean iSuccess
    Boolean iBAscending
    String sTemp1

    Get Create (RefClass(cComChilkatXml)) To hoXml
    If (Not(IsComObjectCreated(hoXml))) Begin
        Send CreateComObject of hoXml
    End

    // The sample input XML is available at http://www.chilkatsoft.com/data/fruitRecordsSort.xml
    Get ComLoadXmlFile Of hoXml "fruitRecordsSort.xml" To iSuccess
    If (iSuccess <> True) Begin
        Get ComLastErrorText Of hoXml To sTemp1
        Showln sTemp1
        Procedure_Return
    End

    // 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.
    Get ComFindChild Of hoXml "fruits" To vXSortRoot
    If (IsComObject(vXSortRoot)) Begin
        Get Create (RefClass(cComChilkatXml)) To hoXSortRoot
        Set pvComObject Of hoXSortRoot To vXSortRoot
    End

    // Sort by the "name" field in ascending order.
    Move True To iBAscending
    Send ComSortRecordsByContent To hoXSortRoot "name" iBAscending

    // Show the result:
    Get ComGetXml Of hoXml To sTemp1
    Showln sTemp1

    // <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>

    Send Destroy of hoXSortRoot


End_Procedure