FOR EACH/FOR ALL statement (loop through a variable of type XMLReader)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

This content has been translated automatically. Click here to view the French version.

Help / WLanguage / WLanguage syntax / Structured statements

Syntax 1: Browsing XML file elements on one level
Syntax 2: Route on one level with copy
Syntax 3: Depth travel
Loop through an XMLDocument variable

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

FOR EACH/FOR ALL statement (loop through a variable of type XMLReader)

In french: POUR TOUT / POUR TOUS

The FOR EACH statement loops through a variable of type xmlReader in various ways:

Loop through a level.
Loop through a level with copy.
In-depth loop.

Note: The FOR EACH, FOR ALL statements are accepted. The FOR EACH statement will be used in this documentation but it can be replaced with FOR ALL.

Example

<?xml version="1.0"?>
<aa>
<bb>
Text1

<cc>
</cc>
</bb>
<bb>
<cc>
</cc>
</bb>
</aa>

// Loop through a level
// Reader is the variable corresponding to the XML file
FOR EACH Reader
// Read the start aa and end aa tags
FOR EACH Reader
// Read the start bb, end bb, start bb, end bb tags
FOR EACH Reader
// Read Text1 and the start cc, end cc
// start cc, end cc tags
END
END
END

// Reader is the variable corresponding to the XML file
FOR EACH Reader IN-DEPTH
// Read the start aa, start bb, text1,
// start cc, end cc, end bb, start bb,
// start cc, end cc, end bb, end aa tags
END

Syntax

Iterating over the elements of the XML file on a level Hide the details

FOR EACH <XML Reader>
FOR EACH <XML Reader>
...
END
END

<FOR EACH>:

Marks the beginning of the statement block.
Used to iterate over the children of the current level.

<XML Reader>:

xmlReader variable corresponding to the XML file to loop through.
Inside the loop, the xmlReader variable points to the current XML element.
Note: It is possible to nest paths on the XML player.

Loop through a level with copy Hide the details

FOR EACH <Element> OF <XML Reader>
FOR EACH <Element A> OF <Element>
...
END
END

<FOR EACH>:

Marks the beginning of the statement block.
Used to iterate over the children of the current level.

<Element>:

Inside the loop, <Element> points to the current XML element. It can be used to perform a new FOR EACH loop to iterate over its children.

<XML Reader>:

xmlReader variable corresponding to the XML file to loop through.

In-depth loop Hide the details

FOR EACH <XML Reader> IN-DEPTH
...
END

FOR EACH <Element> OF <XML Reader> IN-DEPTH
...
END

<FOR EACH>:

Marks the beginning of the statement block.
Goes deep into the XML tree: traverses son, then grandson, then grandson's son to a leaf, continuing.

<Element>:

Inside the loop, <Element> points to the current XML element. Used to perform a reading in depth from an element.

<XML Reader>:

xmlReader variable corresponding to the XML file to loop through.

Remarks

Syntax 1: Browsing XML file elements on one level

This syntax is used to iterate over the children of the current level. Inside the loop, the xmlReader variable points to the current XML element.

You can nest loops on the xmlReader variable to iterate over the children of the element on the current level.

Syntax 2: Route on one level with copy

This syntax is used to iterate over the children of the current level. Inside the loop, <Element> points to the current XML element and it is possible to use it to perform another loop on its own children.

Note: It is possible to perform only one browse on the variable <Elément>.

Syntax 3: Depth travel

This syntax allows you to traverse the XML tree in depth, i.e. son, then grandson, ... until you reach a leaf. When the leaf is reached, the loop goes to the next child.

Loop through an XMLDocument variable

If the XML file is handled via a variable of type XMLDocument, you can loop through the data file directly.

For example:

// Use of FOR EACH <xmlNode> OF <xmlNode or xmlDocument> 
// ON <Node name> WHERE <CONDITION>

// Search for all the rows in the invoice with a VAT of 20
sXML is string=[
<?xml version="1.0" encoding="UTF-8"?>
<INVOICE>
	<HEADER>
		<CLIENTID>123465</CLIENTID>
		<NAME>M. Henry DOUGLAS</NAME>
	</HEADER>
	<ROWS>
		<ROW TYPE="PRODUCT" CODE="CD1" QTY="2" VATTYP="5.5">51</ROW>
		<ROW TYPE="PRODUCT" CODE="CD2" QTY="1" VATTYP="20">52</ROW>
		<ROW TYPE="PRODUCT" CODE="CD3" QTY="3" VATTYP="5.5">53</ROW>
		<ROW TYPE="PRODUCT" CODE="CD4" QTY="1" VATTYP="20">54</ROW>
		<ROW TYPE="PRODUCT" CODE="CD5" QTY="1" VATTYP="20">55</ROW>
		<ROW TYPE="PRODUCT" CODE="CD6" QTY="1" VATTYP="5.5">56</ROW>
	</ROWS>
	<TOTALS>
		<VAT TYPE="5.5">55</VAT>
		<VAT TYPE="20">200</VAT>
		<TOTALBT>1000</TOTALBT>
		<SHIPCOST>10</SHIPCOST>
	</TOTALS>
</INVOICE>
]

resultXML is xmlDocument = XMLOpen(sXML, fromString)
IF ErrorOccurred THEN
	Error("Unable to open the XML file", ErrorInfo())
	RETURN
END
// Loop through "INVOICE.ROWS" only 
// on the subnodes with the name "ROW" 
// and where the "VATTYP" attribute is set to "20" 
FOR EACH RowNode OF resultXml.INVOICE.ROWS 
			ON ROW where RowNode:VATTYP.Value = "20"
	Trace("Item " + RowNode:CODE.Value + " x " + ...
		RowNode:QTY.Value+" = " + RowNode..Text)
END