Execute (Command Object)
|(if the call to Execute returns records)|
|(if the call to Execute does not return records)|
Executes a query, SQL statement, or stored procedure. If it results in the creation of a recordset, that recordset can be immediately assigned to a Recordset object variable.
A Recordset object that you want initialized and set equal to the collection of records returned by the call to the Execute method.
The name of the Command object whose Execute method you are calling.
An optional Long variable that, when the method returns, indicates how many records were affected by the call.
An array of variants containing parameters for the command to be executed. You should not put output parameters here, since they will not be returned properly.
The Options parameter can be used to specify the type of command being executed or the Execute options desired.
The ADO constant values for the command type are the same as those for the Command.CommandType property:
This indicates that the CommandType property has not yet been specified.
The command is a text command, such as a simple SQL statement; CommandText is evaluated as a textual definition of a command.
The Command object represents a table; CommandText is evaluated as the name of a ...