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

Script
Execute(
  record
)

Parameters

record

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

Return 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

Send comments about this topic to Microsoft

Build date: 8/13/2009