Difference between revisions of "SET XMLFORMAT"
Yvonnemilne (Talk | contribs) |
Yvonnemilne (Talk | contribs) (→Example) |
||
| Line 24: | Line 24: | ||
| − | ==Example==<pre> | + | ==Example== <pre> |
set xmlformat to ADO | set xmlformat to ADO | ||
EXEC SQL | EXEC SQL | ||
| Line 34: | Line 34: | ||
| − | </pre>==Products== | + | </pre> ==Products== |
Recital Database Server, Recital Mirage Server, Recital Terminal Developer | Recital Database Server, Recital Mirage Server, Recital Terminal Developer | ||
Revision as of 12:38, 10 March 2009
Contents
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"
==ProductsExample==
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
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"
Recital Database Server, Recital Mirage Server, Recital Terminal Developer
