Difference between revisions of "XMLCOUNT()"
From Recital Documentation Wiki
Yvonnemilne (Talk | contribs) |
Yvonnemilne (Talk | contribs) |
||
Line 1: | Line 1: | ||
− | |||
− | |||
− | |||
==Class== | ==Class== | ||
XML | XML | ||
Line 15: | Line 12: | ||
==See Also== | ==See Also== | ||
− | [[ | + | [[COPY]], [[FETCH]], [[SQL SELECT|SELECT]], [[SQL UPDATE|UPDATE]], [[XMLCREATEDTD()]], [[XMLVALIDATE()]], [[XMLFIRST()]], [[XMLNEXT()]] |
Line 45: | Line 42: | ||
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:Functions]] | [[Category:Functions]] | ||
+ | [[Category:XML]] | ||
+ | [[Category:XML Functions]] |
Revision as of 15:26, 2 June 2009
Class
XML
Purpose
Function to return the number of records from an XML file
Syntax
XMLCOUNT(<XML filename>)
See Also
COPY, FETCH, SELECT, UPDATE, XMLCREATEDTD(), XMLVALIDATE(), XMLFIRST(), XMLNEXT()
Description
The XMLCOUNT() function will return the number of records from an XML file.
Parameters | Required | Default | Description |
---|---|---|---|
<XML filename> | Yes | None | The name of the XML file to validate. |
If the XML file contains no records, then a value of zero will be returned.
Example
select company, street, town, state, zip from sales save as xml sales ? xmlcount("sales.xml") 25
Products
Recital Database Server, Recital Mirage Server, Recital Terminal Developer