Visual FoxPro

Demonstrate the XML FindNextRecord Method

See more XML Examples

Imagine we have an XML file as follows:

<CompleteMultipartUpload>
  <Part>
    <PartNumber>1</PartNumber>
    <ETag>abc</ETag>
  </Part>
  <Part>
    <PartNumber>2</PartNumber>
    <ETag>def</ETag>
  </Part>
  <Part>
    <PartNumber>3</PartNumber>
    <ETag>ghi</ETag>
  </Part>
</CompleteMultipartUpload>

We want to find the record where PartNumber = 2. To do so, we simply position ourselves at the first "Part" tag, and then call FindNextRecord. (See below..) Visual FoxPro

LOCAL loXml
LOCAL loFoundRec

loXml = CreateObject('Chilkat.Xml')

loXml.LoadXmlFile("qa_data/xml/multipartUpload.xml")

* Position ourselves at the 1st record.
loXml.GetChild2(0)

loFoundRec = loXml.FindNextRecord("PartNumber","2")
IF (loXml.LastMethodSuccess = 1) THEN
    ? "Found the record where PartNumber = 2."
    ? loFoundRec.GetXml()

    * Let's examine the ETag for this record...
    ? "ETag for PartNumber 2 = " + loFoundRec.GetChildContent("ETag")
    RELEASE loFoundRec
ELSE
    ? "No record exists where PartNumber = 2."
ENDIF

* What if we want to find the record where ETag = "abc"?
loFoundRec = loXml.FindNextRecord("ETag","abc")
IF (loXml.LastMethodSuccess = 1) THEN
    ? "Found the record where ETag = abc"
    ? loFoundRec.GetXml()

    * Let's examine the PartNumber for this record...
    ? "Part number for Etag(abc) = " + loFoundRec.GetChildContent("PartNumber")
    RELEASE loFoundRec
ELSE
    ? "No record exists where ETag = abc."
ENDIF

* Go back to the XML root..
loXml.GetRoot2()

RELEASE loXml