Difference between revisions of "XMLNEXT()"

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 read the next record contained in the XML file specified with the XMLFIRST() function and return the number of fields in the record
 
Function to read the next record contained in the XML file specified with the XMLFIRST() function and return the number of fields in the record
Line 12: Line 8:
  
 
==See Also==
 
==See Also==
[[COPY]], [[FETCH]], [[SQL SELECT|SELECT]], [[SET XMLFORMAT]], [[SQL UPDATE|UPDATE]], [[XMLCOUNT()]], [[XMLCREATEDTD()]], [[XMLFIRST()]], [[XMLVALIDATE()]]
+
[[COPY]], [[FETCH]], [[SQL SELECT|SELECT]], [[SET XMLFORMAT]], [[SQL UPDATE|UPDATE]], [[XML]], [[XML_DECODE()]], [[XML_ENCODE()]], [[XML_GATHER()]], [[XML_SCATTER()]], [[XMLCOUNT()]], [[XMLCREATEDTD()]], [[XMLFIRST()]], [[XMLVALIDATE()]]
  
  
Line 45: Line 41:
  
 
==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:21, 19 November 2009

Purpose

Function to read the next record contained in the XML file specified with the XMLFIRST() function and return the number of fields in the record


Syntax

XMLNEXT(<memvar1>, <memvar2>, <array1>, <array2>)


See Also

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


Description

The XMLNEXT() function will read the next record contained in the XML file specified with the XMLFIRST() function, returning the number of fields in the record. The XMLFIRST() function must be called first before the XMLNEXT() function can be used.


Parameters Required Default Description
<memvar1> Yes None The name of a memory variable that will return the transaction type for the record. Valid types are INSERT, UPDATE and DELETE.
<memvar2> Yes None The name of a memory variable that will return the where condition for the transaction if it is an UPDATE or DELETE type.
<array1> Yes None The name of an array that will be created that contains all the field names for the record.
<array2> Yes None The name of an array that will be created that contains all the data each field for the record.


The XMLNEXT() function will return -1 if it fails or where there are no more records left in the XML file, as some transaction type can contain zero fields.


Example

number = xmlnext(trans, where, names, data)
? number
        30


Products

Recital, Recital Server