Difference between revisions of "XMLCOUNT()"

From Recital Documentation Wiki
Jump to: navigation, search
 
(One intermediate revision by one user not shown)
Line 1: Line 1:
==Class==
 
XML
 
 
 
 
==Purpose==
 
==Purpose==
 
Function to return the number of records from an XML file
 
Function to return the number of records from an XML file
Line 12: Line 8:
  
 
==See Also==
 
==See Also==
[[COPY]], [[FETCH]], [[SQL SELECT|SELECT]], [[SET XMLFORMAT]], [[SQL UPDATE|UPDATE]], [[XMLCREATEDTD()]], [[XMLFIRST()]], [[XMLNEXT()]], [[XMLVALIDATE()]]
+
[[COPY]], [[FETCH]], [[SQL SELECT|SELECT]], [[SET XMLFORMAT]], [[SQL UPDATE|UPDATE]], [[XML]], [[XML_DECODE()]], [[XML_ENCODE()]], [[XML_GATHER()]], [[XML_SCATTER()]], [[XMLCREATEDTD()]], [[XMLFIRST()]], [[XMLNEXT()]], [[XMLVALIDATE()]]
  
  
Line 39: Line 35:
  
 
==Products==
 
==Products==
Recital Database Server, Recital Mirage Server, Recital Terminal Developer
+
Recital, Recital Server
 
[[Category:Documentation]]
 
[[Category:Documentation]]
 
[[Category:Functions]]
 
[[Category:Functions]]
 
[[Category:XML]]
 
[[Category:XML]]
 
[[Category:XML Functions]]
 
[[Category:XML Functions]]

Latest revision as of 14:17, 19 November 2009

Purpose

Function to return the number of records from an XML file


Syntax

XMLCOUNT(<XML filename>)


See Also

COPY, FETCH, SELECT, SET XMLFORMAT, UPDATE, XML, XML_DECODE(), XML_ENCODE(), XML_GATHER(), XML_SCATTER(), XMLCREATEDTD(), XMLFIRST(), XMLNEXT(), XMLVALIDATE()


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, Recital Server