The XML SQLStatementExport Method

See Also

The XML SQLStatementExport method works in a similar fashion to the SQLExport method. For both methods, the XML document generated has the same format (for more information on the format, see also: "The XML.SQLExport Method"). The difference is that SQLStatementExport executes a dynamic statement passed as the input parameter.

SYNTAX

INVOKE XML.SQLStatementExport

WITH

SELECT <sql-statement as string>

EXAMPLE

INVOKE XML.SQLStatementExport

WITH

SELECT 'select * from employee'

or:

INVOKE XML.SQLStatementExport

WITH

SELECT sql_statement

FROM my_report_table