Execute SQL Statements

The VBScript file WiRunSQL.vbs is provided in the Windows SDK Components for Windows Installer Developers. This sample shows how script is used to run SQL queries and updates against a Windows Installer database. For more information, see SQL Syntax and Examples of Database Queries Using SQL and Script.

The sample script demonstrates:

• OpenDatabase method (Installer Object) and the LastErrorRecord method of the Installer Object
• OpenView method, and the Commit method of the Database Object
• Execute method of the View Object
• StringData property propertyof the Record Object

Using this sample requires the CScript.exe or WScript.exe version of Windows Script Host. To use CScript.exe to run this sample, type a command at the command prompt using the following syntax. Help is displayed if the first argument is /? or if too few arguments are specified. To redirect the output to a file, end the command line with VBS > [path to file]. The sample returns a value of 0 for success, 1 if help is invoked, and 2 if the script fails.

cscript WiRunSQL.vbs [path to database][SQL queries]

Specify the path to a Windows Installer database. Specify the SQL queries that are to be executed. Note that the SQL query must be enclosed in double quotes. SELECT queries display the rows of the result list specified in the query. Binary data columns selected by a query are not displayed.

For additional scripting examples, see Windows Installer Scripting Examples. For sample utilities that do not require Windows Script Host, see Windows Installer Development Tools.

For more information, see Working with Queries and Examples of Database Queries Using SQL and Script. The sample A Localization Example demonstrates using SQL for Localizing Database Columns and Updating a Summary Information Stream.