Lianja

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..) Lianja

loXml = createobject("CkXml")

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

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

loFoundRec = loXml.FindNextRecord("PartNumber","2")
if (loXml.LastMethodSuccess = .T.) 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 = .T.) 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