Difference between revisions of "SET XMLFORMAT"

From Recital Documentation Wiki
Jump to: navigation, search
Line 18: Line 18:
  
 
==Description==
 
==Description==
The SET XMLFORMAT TO <RECITAL \| ADO> command allows you to specify the default format for XML files created by SELECT...SAVE AS XML.  The XMLFORMAT can be either RECITAL or ADO (Microsoft® ActiveX® Data Objects).  Any XML files created in the ADO format can be loaded with the Open method of an ADO Recordset object.
+
The SET XMLFORMAT TO <RECITAL | ADO> command allows you to specify the default format for XML files created by SELECT...SAVE AS XML.  The XMLFORMAT can be either RECITAL or ADO (Microsoft® ActiveX® Data Objects).  Any XML files created in the ADO format can be loaded with the Open method of an ADO Recordset object.
  
 
The default XMLFORMAT setting is ADO.  The default XMLFORMAT setting can also be overridden using the FORMAT clause on the SELECT statement.
 
The default XMLFORMAT setting is ADO.  The default XMLFORMAT setting can also be overridden using the FORMAT clause on the SELECT statement.
Line 27: Line 27:
 
set xmlformat to ADO
 
set xmlformat to ADO
 
EXEC SQL
 
EXEC SQL
SELECT \* FROM example
+
SELECT * FROM example
 
SAVE AS XML example;
 
SAVE AS XML example;
 
// In Visual Basic the file can then be loaded:
 
// In Visual Basic the file can then be loaded:

Revision as of 10:52, 11 March 2009

SET XMLFORMAT

Class

SQL Applications


Purpose

Specify the default format for XML files created by SELECT...SAVE AS XML


Syntax

SET XMLFORMAT TO <RECITAL | ADO>

See Also

SELECT


Description

The SET XMLFORMAT TO <RECITAL | ADO> command allows you to specify the default format for XML files created by SELECT...SAVE AS XML. The XMLFORMAT can be either RECITAL or ADO (Microsoft® ActiveX® Data Objects). Any XML files created in the ADO format can be loaded with the Open method of an ADO Recordset object.

The default XMLFORMAT setting is ADO. The default XMLFORMAT setting can also be overridden using the FORMAT clause on the SELECT statement.


Example

set xmlformat to ADO
EXEC SQL
SELECT * FROM example
SAVE AS XML example;
// In Visual Basic the file can then be loaded:
// Set adoPrimaryRS = New Recordset
// adoPrimaryRS.Open "example.xml"


Products

Recital Database Server, Recital Mirage Server, Recital Terminal Developer