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. |