We use cookies on our website to analyze website usage and to help secure the website against misuse. Advertising and functional cookies are not used in our site or our web application products.
By clicking “Accept Essential Cookies Only”, you consent to us placing these cookies.
Execute a SQL statement and load the results into the AMSX XML buffer
Runs a SQL query and converts the result set into an XML document, which is stored in the AMSX XML buffer (mdoc). The root element uses the table name provided. An optional compress flag controls whitespace handling.
| Parameter | Description |
|---|---|
| cmd | Table name used as the XML root element |
| Argument 0 | SQL statement to execute |
| Argument 1 | Compress flag (true to compress, default true) |
SqlToXML "Table name used as the XML root element", "SQL statement to execute", "Compress flag (true to compress, default true)"