SQL Query Tab
This tab allows you to configure the selected SQL query.
Execution
Set the execution options for the SQL query.
Schedule Action to Run SQL Query
The SQL query can be triggered by scheduling the associated custom action in the install execution stage or by directly invoking the custom action with a published event.
Abort installation in case of error
Abort the installation if an error is encountered during query execution.
You can suppress the spawned message box for the SQL
query operation by setting the
SqlSuppressSpawnMsgBox property to
1. You can set this property
statically (from Install Parameters) or dynamically (from the
installer UI - associated with an
Edit Control or with a Set installer property
value Initialization/Published Event).
Data Binding
This section allows you to configure data bindings for your SQL query.
Adding a new data binding
Use the Insert key while the list control is focused.
button, the “New...” context menu item or press theMoving a data binding
Use the Page Up, Page Down keys while the list control is focused.
, buttons, the “Up”, “Down” context menu items or press theThe top-bottom order of the data bindings is important because it
will represent the left-right columns order in the result set.
Removing a data binding
Use the Delete key while an element from the list control is focused.
button, the “Remove” context menu item or press theResults
The specified binding properties will be used by Advanced Installer to return the result set values:
- any ComboBox control that has the above specified properties associated with it.
- any ListBox control that has the above specified properties associated with it.
- the first row from the result set will be bound directly to the above specified properties.
For an example on how data bindings are set in an SQL query follow
SQL Query Examples.
SQL
Script File
Specify the file for the query. Use
button to select it.Script Inline
Use the embedded editor to instantly create a query on the fly.
Statement separator (SQL Batch file separator)
Specify the separator for the SQL statements.
By default this field is empty; if you supply a statement
separator (Eg. semicolon ; or GO
), during installation the SQL script batch file will be
automatically split into component statements using the supplied
statement separator and each SQL statement will be executed
individually. Otherwise, SQL script will be executed as a whole.
Format: with the exception of semicolon ;
, the statement separator must always begin with a
letter and can contain only
alpha-numeric characters.
Some Database Servers do not permit executing multiple statements at
once. In this case supply a statement separator to indicate that the SQL
queries should be executed individually. For more information please
read Why does my SQL Script fail to run when
executed from the installer? FAQ.
Strip comments from SQL script
Removes all comments from the SQL script. (This option also removes SQL comments from your stored procedures, if any.)
Disclaimer
Make sure the SQL code you supply is well-tested before
deployment. If errors occur during installation, the changes cannot be
undone. This functionality assumes familiarity with SQL syntax. Advanced Installer
Technical Support does not provide assistance with debugging SQL
statements.
Topics
- SQL Query Examples
Examples on how data binding is set in an SQL Query.