Visual FoxPro

XML Sort by Content

See more XML Examples

Demonstrates the SortByContent method.

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

<root>
    <fruits>
        <apples>
            <apple>fuji</apple>
            <apple>gala</apple>
            <apple>granny smith</apple>
            <apple>honeycrisp</apple>
            <apple>mcintosh</apple>
        </apples>
        <fruit>banana</fruit>
        <fruit>blackberry</fruit>
        <fruit>blueberry</fruit>
        <fruit>orange</fruit>
        <fruit>pear</fruit>
    </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/fruitSort2.xml
lnSuccess = loXml.LoadXmlFile("fruitSort2.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.SortByContent(lnBAscending)

*  Show the result:
? loXml.GetXml()

*  Note:  The "apples" node contains child nodes, but its 
*  text content is 0-length (empty).  Therefore, when sorting in
*  ascending order, it will be positioned before the direct
*  children containing non-empty content.

*  <root>
*      <fruits>
*          <apples>
*              <apple>granny smith</apple>
*              <apple>gala</apple>
*              <apple>fuji</apple>
*              <apple>mcintosh</apple>
*              <apple>honeycrisp</apple>
*          </apples>
*          <fruit>banana</fruit>
*          <fruit>blackberry</fruit>
*          <fruit>blueberry</fruit>
*          <fruit>orange</fruit>
*          <fruit>pear</fruit>
*      </fruits>
*  </root>

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

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

*  <root>
*      <fruits>
*          <apples>
*              <apple>fuji</apple>
*              <apple>gala</apple>
*              <apple>granny smith</apple>
*              <apple>honeycrisp</apple>
*              <apple>mcintosh</apple>
*          </apples>
*          <fruit>banana</fruit>
*          <fruit>blackberry</fruit>
*          <fruit>blueberry</fruit>
*          <fruit>orange</fruit>
*          <fruit>pear</fruit>
*      </fruits>
*  </root>

RELEASE loXSortRoot

RELEASE loXml