Advanced SQL Data Retrieval: Mastering the Query Editor

Table of Contents

• Introduction
• Registration
• Using Advanced Installer
  • GUI
  • Working with Projects
  • Installer Project
    * Product Information
    * Resources
    * Package Definition
    * Requirements
    * User Interface
    * System Changes
    * Server
    * Internet Information Services Page”)
    * ODBC
    * SQL Databases
    * Database server
    * Predefined SQL Connection
    * Custom SQL Connection
    * SQLite 3 Connection
    * SQL Query Tab
    * SQL Query Examples
    * SQL Script Tab
    * Script Replacements Tab
    * SSRS Deployments
    * SQL Operations
    * SharePoint Page
    * Silverlight Page
    * Custom Behavior
  • Patch Project
  • Merge Module Project
  • Updates Configuration Project
  • Windows Store App Project
  • Modification Package Project
  • Optional Package Project
  • Windows Mobile CAB Projects
  • Visual Studio Extension Project
  • Software Installer Wizards - Advanced Installer
  • Visual Studio integration
  • Alternative to AdminStudio/Wise
  • Replace Wise
  • Migrating from Visual Studio Installer
  • Keyboard Shortcuts
  • Shell Integration
  • Command Line
  • Advanced Installer PowerShell Automation Interfaces
• Features and Functionality
• Tutorials
• Samples
• How-tos
• FAQs
• Windows Installer
• Deployment Technologies
• IT Pro
• MSIX
• Video Tutorials
• Advanced Installer Blog
• Table of Contents

Disclaimer: This post includes affiliate links

If you click on a link and make a purchase, I may receive a commission at no extra cost to you.

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 theSqlSuppressSpawnMsgBox property to1. You can set this property_statically_ (from Install Parameters ) or dynamically (from theinstaller UI - associated with anEdit 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.

Click here

Adding a new data binding

Use the [New… ] button, the “New…” context menu item or press theInsert key while the list control is focused.

Moving a data binding

Use the [Up ], [Down ] buttons, the “Up”, “Down” context menu items or press the Page Up, Page Down keys while the list control is focused.

The 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 [Remove ] button, the “Remove” context menu item or press theDelete key while an element from the list control is focused.

Results

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 followSQL 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.

Did you find this page useful?

Please give it a rating:

Thanks!

Report a problem on this page

Information is incorrect or missing

Information is unclear or confusing

Something else

Can you tell us what’s wrong?

Send message

Also read: