ADO Command Object

The Command Object |
A Command object is a definition of a specific command that you intend to execute against a data source.

Cancel |
| Method
Cancels execution of a pending Execute or Open call.

CreateParameter |
Returns: Parameter | Method
Creates a new Parameter object.

Execute |
Returns: Recordset | Method
Executes the query, SQL statement, or stored procedure a specified in the CommandText property.

ActiveConnection |
Returns: Variant | Property
Indicates to which Connection object the command currently belongs.

CommandText |
Returns: String | Property
Contains the text of a command to be issued against a data provider.

CommandTimeout |
Returns: Long | Property
Indicates how long to wait, in seconds, while executing a command before terminating the command and generating an error. Default is 30.

CommandType |
Returns: CommandType Enum | Property
Indicates the type of Command object.

Name |
Returns: String | Property
Indicates the name of the Command object.

Parameters |
Returns: Parameters | Property
Contains all of the Parameter objects for a Command object.

Prepared |
Returns: Boolean | Property
Indicates whether or not to save a compiled version of a command before execution.

Properties |
Returns: Properties | Property
Contains all of the Property objects for a Command object.

State |
Returns: Long | Property
Describes whether the Command object is open or closed. Read only.