DataFlex

XML Sort Records by Content

See more XML Examples

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>

DataFlex

Use ChilkatAx-win32.pkg

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

    Move False To iSuccess

    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