MSI.ViewExecute

boolean MSI.ViewExecute ( 

number hView,

number hRecord )

Description

Calls the MsiViewExecute function that executes a SQL view query and supplies any required parameters. The query uses the question mark token to represent parameters as described in SQL Syntax. The values of these parameters are passed in as the corresponding fields of a parameter record. This action must be called before any calls to MSI.ViewFetch.

Parameters

hView

(number) Handle to the view upon which to execute the query.

hRecord

(number) Handle to a record that supplies the parameters. This parameter contains values to replace the parameter tokens in the SQL query. It is optional, so hRecord can be zero. For a reference on syntax, see SQL Syntax.

Returns

(boolean)  Returns true if the action is successful, or false if it wasn't or if an error occurs. You can use Application.GetLastError to determine whether this action failed, and why. You can also retrieve extended error information using the MSI.GetLastErrorRecord action.

See also:  Related Actions