Administration Guide

Execute SQL

Execute SQL operations run SQL expressions or scripts that query the database at runtime.

You configure this operation as follows:

  1. In the SQL Execute dialog box, specify a SQL expression or script containing Transact-SQL statements.

    To insert dynamic values such as Function parameters, click the Insert Placeholder button and select a placeholder (see Inserting Placeholders).

  2. Keep the Enable operation check box selected. Otherwise, this operation will be ignored.

  3. Click OK.

    NOTE: Creating SQL expressions and scripts requires a good knowledge of Transact-SQL. For information about Transact-SQL (T-SQL) syntax, statements, functions, and language elements, see the Microsoft Transact-SQL Reference: https://learn.microsoft.com/en-us/sql/t-sql/language-reference/.

IMPORTANT: In order to have the most current data at runtime Alloy Navigator always runs Execute SQL operations last, after saving all changes made by Update Field and Create Object operations.