Syntax

rst=cnn.Execute(commandText,recordsAffected,options)

Parameters

commandText
Optional. String value that contains the SQL statement, table name, stored procedure, or provider-specific text to execute.
  
recordsAffected
VOID. Does not supported in the current version. Set it to VOID if you have to specify options parameter.
  
options
Optional. Integer value that indicates how the provider should evaluate the commandText argument. It may be a bitmask of one or more CommandTypeEnum or ExecuteOptionEnum values.

Returns

Newly created Recordset wrapper object that contains returned records if any.

Description

Calls the Execute() method of the wrapped ADODB.Connection object. Using the Execute method on a Connection object executes whatever query you pass to the method in the commandText argument on the specified connection. If the commandText argument specifies a row-returning query, any results that the execution generates are stored in a new Recordset object. If the command is not a row-returning query, the provider returns a closed Recordset object.
The returned Recordset object is always a read-only, forward-only cursor. If you need a Recordset object with more functionality, first create a Recordset object with the desired property settings, then use the Recordset object's Open method to execute the query and return the desired cursor type.
The contents of the commandText argument are specific to the provider and can be standard SQL syntax or any special command format that the provider supports.