View object

The View object represents a result set obtained when processing a query using the OpenView method of the Database object. Before any data can be transferred, the query must be executed using the Execute method, passing to it all replaceable parameters designated within the SQL query string. The query may be executed again, with different parameters if needed, but only after freeing the result set either by fetching all the records or by calling the Close method.

Members

The View object has these types of members:

Methods

The View object has these methods.

Method Description
Close Terminates query execution and releases database resources.
Execute Uses the question mark token to represent parameters in a SQL query. The values of these parameters are passed in as the corresponding fields of a parameter record.
Fetch Returns a Record object containing the requested column data if more rows are available in the result set, otherwise, it returns null.
GetError Returns the Validation error and column name for which the error occurred.
Modify Modifies a database row with a modified Record object obtained by the Fetch method.

 

Properties

The View object has these properties.

Property Description
ColumnInfo
Returns a Record object containing the requested information about each column in the result set.

 

Requirements

Version
Windows Installer 5.0 on Windows Server 2012, Windows 8, Windows Server 2008 R2 or Windows 7. Windows Installer 4.0 or Windows Installer 4.5 on Windows Server 2008 or Windows Vista. Windows Installer on Windows Server 2003 or Windows XP
DLL
Msi.dll
IID
IID_IView is defined as 000C109C-0000-0000-C000-000000000046

See also

Windows Installer Scripting Examples