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.
The View object has these types of members:
The View object has these methods.
|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.
The View object has these properties.
||Returns a Record object containing the requested information about each column in the result set.
||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
||IID_IView is defined as 000C109C-0000-0000-C000-000000000046