InstallShield 2015
You can use InstallShield MSI Query to test SQL statements using the Windows Installer version of SQL before you run them in your build script. You can quickly see if a SQL statement is formatted correctly and view the results that it generates.
To run a query:
| 1. | Open InstallShield MSI Query. |
| 2. | On the File menu, click Open. The Open dialog box opens. |
| 3. | Select the database (.msi or .msm file) that you want to use for your test, and then click OK. InstallShield MSI Query lists the name of the file in its title bar. |
| 4. | In the Query box, enter the query that you want to run. |
InstallShield MSI Query lets you enter one or more parameter values as question marks (?). If you include question marks in your query, InstallShield MSI Query displays an Arguments row below the Query box. Each question mark corresponds with a different Arguments box. Use the Arguments boxes to specify the replacement values.
To learn about valid SQL query strings for Windows Installer, see SQL Syntax in the Windows Installer Help Library.
| 5. | Click the Execute button. |
InstallShield MSI Query runs the specified query for the selected database. If you would like to save any changes that occurred as a result of the query, click Save on the File menu.
See Also
InstallShield 2015 Help LibraryJune 2015 |
Copyright Information | Contact Us |