Miscellaneous utilities

SQL – Execute an SQL statement

151 views June 1, 2018 admin 1

Overview

This Custom Field executes an SQL statement. The data Sources are virtual tables. It requires the Relational module.

Syntax

SQL(‘SQLstatement’,‘OutputFormat’)

SQL(‘SELECT * FROM ”SHIRTS” WHERE SIZE = ‘XXL’,‘HTML’)

Element Description
SQLstatement The SQL statement to execute.
OutputFormat The output format. Valid values are ‘XML’, ‘HTML’, ‘HTMLnoheader’, ‘text’, ‘textnoheader’

Example

SQL(‘SELECT * FROM ”SHIRTS” WHERE SIZE = ‘XXL’,‘text’)

SHIRTS SIZE
Style A S
Style A L
Style A XXL
Style B S
Style B M
Style C XXL

In the above example SQL(‘SELECT * FROM ”SHIRTS” WHERE SIZE = ‘XXL’,‘text’) will return ‘Style A, Style C‘.

See also

Was this helpful?