XMLFIRST()

From Recital Documentation Wiki
Revision as of 15:30, 2 June 2009 by Yvonnemilne (Talk | contribs)

Jump to: navigation, search

Class

XML


Purpose

Function to read the first record contained in the specified XML file and return the number of fields in the record


Syntax

XMLFIRST(<XML filename>, <memvar1>, <memvar2>, <memvar3>, <array1>, <array2>)


See Also

COPY, FETCH, SELECT, SET XMLFORMAT, UPDATE, XMLCOUNT(), XMLCREATEDTD(), XMLNEXT(), XMLVALIDATE()


Description

The XMLFIRST() function will read the first record contained in the specified XML file, returning the number of fields in the record.


Parameters Required Default Description
<XML filename> Yes None The name of the XML file to read.
<memvar1> Yes None The name of a memory variable that will return the XML target table name. Ignored if XMLFORMAT is ADO.
<memvar2> Yes None The name of a memory variable that will return the transaction type for the record. Valid types are INSERT, UPDATE and DELETE. Ignored if XMLFORMAT is ADO.
<memvar3> 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. Ignored if XMLFORMAT is ADO.
<array1> Yes None The name of an array that will be created automatically and loaded with the field names for the record.
<array2> Yes None The name of an array that will be created created automatically and loaded with the data for each field in the record.


The XMLFIRST() function will return -1 if it fails, as some transaction type can contain zero fields. The XML file format is set to ADO (Microsoft® ActiveX® Data Objects XML Format) by default. The SET XMLFORMAT command can be used to toggle the XML file format between ADO and Recital.


Example

number = xmlfirst("sales.xml", target, trans, where, names, data)
? number
        30


Products

Recital Database Server, Recital Mirage Server, Recital Terminal Developer