(Visual FoxPro) 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

LOCAL loXml
LOCAL loXSortRoot
LOCAL lnSuccess
LOCAL lnBAscending

* For versions of Chilkat < 10.0.0, use CreateObject('Chilkat_9_5_0.Xml')
loXml = CreateObject('Chilkat.Xml')

* The sample input XML is available at http://www.chilkatsoft.com/data/fruitRecordsSort.xml
lnSuccess = loXml.LoadXmlFile("fruitRecordsSort.xml")
IF (lnSuccess <> 1) THEN
    ? loXml.LastErrorText
    RELEASE loXml
    CANCEL
ENDIF

* 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.
loXSortRoot = loXml.FindChild("fruits")

* Sort by the "name" field in ascending order.
lnBAscending = 1
loXSortRoot.SortRecordsByContent("name",lnBAscending)

* Show the result:
? loXml.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>

RELEASE loXSortRoot

RELEASE loXml