View.Execute method

The Execute method of the View object uses the question mark token to represent parameters in an SQL statement. For more information, see SQL Syntax. The values of these parameters are passed in as the corresponding fields of a parameter record.

Syntax

View.Execute(
  record
)

Parameters

record

Optional Record objects that contains the values that replace the parameter tokens (?) in the SQL query.

Return value

This method does not return a value.

Remarks

This method must be called before any calls to the Fetch method.

If the SQL query specifies values with parameter markers (?), a record must be supplied that contains all of the replacement values, which must be in the same order and of the same data type as the parameter markers. When this method is used with INSERT and UPDATE queries, the question mark tokens must precede all the non-parameterized values.

For example, these queries are valid:

UPDATE {table-list} SET {column}= ? , {column}= {constant}

INSERT INTO {table} ({column-list}) VALUES (?, {constant-list})

However these queries are invalid:

UPDATE {table-list} SET {column}= {constant}, {column}=?

INSERT INTO {table} ({column-list}) VALUES ({constant-list}, ? )

If the method fails, you can obtain extended error information by using the LastErrorRecord method.

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