Visual FoxPro

XML SearchForAttribute Method

See more XML Examples

Demonstrates the SearchForAttribute method.

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

<root>
    <searchRoot>
        <fruit color="red">apple</fruit>
        <fruit color="green">pear</fruit>
        <veg color="orange">carrot</veg>
        <meat animal="cow">beef</meat>
        <xyz>
            <fruit color="blue">blueberry</fruit>
            <veg color="green">broccoli</veg>
        </xyz>
        <fruit color="purple">grape</fruit>
        <cheese color="yellow">cheddar</cheese>
    </searchRoot>
    <fruit color="red">strawberry</fruit>
    <fruit color="orange">peach</fruit>
</root>

Visual FoxPro

LOCAL lnSuccess
LOCAL loXml
LOCAL loXSearchRoot
LOCAL loXBeginAfter
LOCAL loXFound
LOCAL loXSearch

lnSuccess = 0

loXml = CreateObject('Chilkat.Xml')

lnSuccess = loXml.LoadXmlFile("qa_data/xml/fruitSearch.xml")
IF (lnSuccess <> 1) THEN
    ? loXml.LastErrorText
    RELEASE loXml
    CANCEL
ENDIF

* Search the sub-tree rooted at "searchRoot"
loXSearchRoot = loXml.FindChild("searchRoot")
IF (loXml.LastMethodSuccess = 0) THEN
    ? "searchRoot not found, searching from root."
    loXSearchRoot = loXml.GetRoot()
ENDIF

* Search for all "fruit" nodes having a color attribute
* where the name of the color ends in "e"
loXBeginAfter = loXSearchRoot.GetSelf()
loXFound = loXSearchRoot.SearchForAttribute(loXBeginAfter,"fruit","color","*e")
DO WHILE (loXSearchRoot.LastMethodSuccess = 1)

    ? loXFound.Content + ": " + loXFound.GetAttrValue("color")

    RELEASE loXBeginAfter
    loXBeginAfter = loXFound
    loXFound = loXSearchRoot.SearchForAttribute(loXBeginAfter,"fruit","color","*e")
ENDDO

* The correct output is:
* grape: purple
* blueberry: blue

RELEASE loXBeginAfter

? "--------------------------"

* ---------------------------------------------------------------------------------
* Now do the same, but instead use SearchForAttribute2
* which updates the internal reference of the caller instead
* of returning the found node.

loXBeginAfter = loXSearchRoot.GetSelf()
loXSearch = loXSearchRoot.GetSelf()

lnSuccess = loXSearch.SearchForAttribute2(loXBeginAfter,"fruit","color","*e")
DO WHILE lnSuccess = 1

    ? loXSearch.Content + ": " + loXSearch.GetAttrValue("color")

    * Copy the internal references so that the next search
    * begins after the found node.
    loXBeginAfter.CopyRef(loXSearch)
    loXSearch.CopyRef(loXSearchRoot)

    lnSuccess = loXSearch.SearchForAttribute2(loXBeginAfter,"fruit","color","*e")
ENDDO

RELEASE loXSearch
RELEASE loXBeginAfter

RELEASE loXSearchRoot

RELEASE loXml