Difference between revisions of "XMLNEXT()"
Yvonnemilne (Talk | contribs) |
Yvonnemilne (Talk | contribs) |
||
| (One intermediate revision by one user not shown) | |||
| Line 1: | Line 1: | ||
| − | |||
| − | |||
| − | |||
| − | |||
==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 | + | 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
