Visual FoxPro

XML Sort by Tag

See more XML Examples

Demonstrates the SortByTag method.

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

<root>
    <fruits>
        <apple>
            <fuji>blah</fuji>
            <gala>blah</gala>
            <grannySmith>blah</grannySmith>
            <honeycrisp>blah</honeycrisp>
            <mcIntosh>blah</mcIntosh>
        </apple>
        <banana>blah</banana>
        <blackberry>blah</blackberry>
        <blueberry>blah</blueberry>
        <orange>blah</orange>
        <pear>blah</pear>
    </fruits>
</root>

Visual FoxPro

LOCAL lnSuccess
LOCAL loXml
LOCAL loXSortRoot
LOCAL lnBAscending

lnSuccess = 0

loXml = CreateObject('Chilkat.Xml')

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

*  Sort the direct children under the "fruits" node by tag:
loXSortRoot = loXml.FindChild("fruits")

*  Sort in ascending order.
lnBAscending = 1
loXSortRoot.SortByTag(lnBAscending)

*  Show the result:
? loXml.GetXml()

*  <root>
*      <fruits>
*          <apple>
*              <grannySmith>blah</grannySmith>
*              <gala>blah</gala>
*              <fuji>blah</fuji>
*              <mcIntosh>blah</mcIntosh>
*              <honeycrisp>blah</honeycrisp>
*          </apple>
*          <banana>blah</banana>
*          <blackberry>blah</blackberry>
*          <blueberry>blah</blueberry>
*          <orange>blah</orange>
*          <pear>blah</pear>
*      </fruits>
*  </root>

*  Sort the direct children under the "apple" node:
lnSuccess = loXSortRoot.FindChild2("apple")

loXSortRoot.SortByTag(lnBAscending)
? loXml.GetXml()

*  <root>
*      <fruits>
*          <apple>
*              <fuji>blah</fuji>
*              <gala>blah</gala>
*              <grannySmith>blah</grannySmith>
*              <honeycrisp>blah</honeycrisp>
*              <mcIntosh>blah</mcIntosh>
*          </apple>
*          <banana>blah</banana>
*          <blackberry>blah</blackberry>
*          <blueberry>blah</blueberry>
*          <orange>blah</orange>
*          <pear>blah</pear>
*      </fruits>
*  </root>

RELEASE loXSortRoot

RELEASE loXml