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 Microsoft SQL Server 2005, see the Transact-SQL Reference at
   http://technet.microsoft.com /en-us/library/ms189826%28v=sql.90%29.aspx If you are using a different version of Microsoft SQL Server, see the relevant resource at Microsoft TechNet.

   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.