Difference between revisions of "SET XMLFORMAT"
From Recital Documentation Wiki
Helengeorge (Talk | contribs) (→Class) |
Yvonnemilne (Talk | contribs) |
||
| (One intermediate revision by one user not shown) | |||
| Line 1: | Line 1: | ||
| − | |||
| − | |||
==Purpose== | ==Purpose== | ||
Specify the default format for XML files created by SELECT...SAVE AS XML | Specify the default format for XML files created by SELECT...SAVE AS XML | ||
| Line 21: | Line 19: | ||
<code lang="recital"> | <code lang="recital"> | ||
set xmlformat to ADO | set xmlformat to ADO | ||
| − | + | SELECT * FROM example; | |
| − | + | SAVE AS XML example | |
| − | SAVE AS XML example | + | |
// In Visual Basic the file can then be loaded like this: | // In Visual Basic the file can then be loaded like this: | ||
| Line 31: | Line 28: | ||
==Products== | ==Products== | ||
| − | Recital | + | Recital Server, Recital |
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:Commands]] | [[Category:Commands]] | ||
Latest revision as of 12:25, 24 December 2009
Purpose
Specify the default format for XML files created by SELECT...SAVE AS XML
Syntax
SET XMLFORMAT TO <RECITAL | ADO>
See Also
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 SELECT * FROM example; SAVE AS XML example // In Visual Basic the file can then be loaded like this: // Set adoPrimaryRS = New Recordset // adoPrimaryRS.Open "example.xml"
Products
Recital Server, Recital
