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.
Methods
The View object defines the following methods.
| Method | Description |
|---|---|
|
Terminates query execution and releases database resources. |
|
|
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. |
|
|
Returns a Record object containing the requested column data if more rows are available in the result set, otherwise, it returns null. |
|
|
Returns the Validation error and column name for which the error occurred. |
|
|
Modifies a database row with a modified Record object obtained by the Fetch method. |
Properties
The View object defines the following property.
| Property | Access type | Description |
|---|---|---|
| Read-only | Returns a Record object containing the requested information about each column in the result set. |
Requirements
| Version | Windows Installer 5.0 on 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, Windows XP, and Windows 2000 |
|---|---|
| DLL | Msi.dll |
| IID | IID_IView is defined as 000C109C-0000-0000-C000-000000000046 |
See Also
Send comments about this topic to Microsoft
Build date: 8/13/2009
© 2009 Microsoft Corporation. All rights reserved.