The Database object accesses an installer database.

The Database object is released when it is either taken out of scope or when the object variable associated with it is set to null. The Commit method must be called before the Database object is released to write out all persistent changes. If the Commit method is not called, the installer performs an implicit rollback upon object destruction.

The client can use the following procedure for data access.

To Query API Sequencing

1. Obtain a Database object by calling the OpenDatabase or the Installer object.
2. Initiate a query using a SQL string by calling the OpenView method of the Database object.
3. Set query parameters in a Record object and execute the database query by calling the Execute method of the View object. This produces a result that can be fetched or updated.
4. Call the Fetch method of the View object repeatedly to return Record objects.
5. Update database rows of a Record object obtained by the Fetch method using the Modify method of the View object.
6. Release the query and any unfetched records by calling the Close method of the View object.
7. Persist any database updates by calling the Commit method of the Database object.

Methods

The Database object defines the following methods.

Properties

The Database object defines the following properties.

Requirements

See Also

Windows Installer Scripting Examples

Send comments about this topic to Microsoft

Build date: 8/13/2009