Command Object

Methods

Name	Returns	Description
Cancel		Cancels execution of a pending Execute or Open call.
CreateParameter	Parameter	Creates a new Parameter object.
Execute	Recordset	Executes the query, SQL statement, or stored procedure specified in the CommandText property.

Properties

Name	Returns	Description
ActiveConnection	Variant	Indicates or sets the Connection object to which the command currently belongs.
CommandText	String	Contains the text of a command to be issued against a data provider.
CommandTimeout	Long	Indicates how long to wait, in seconds, while executing a command before terminating the command and generating an error. Default is 30.
CommandType	CommandTypeEnum	Indicates the type of Command object.
Name	String	Indicates the name of the Command object.
Parameters	Parameters	Contains all of the Parameter objects for a Command object.
Prepared	Boolean	Indicates whether or not to save a compiled version of a command before execution.
Properties	Properties	Contains all of the Property objects for a Command object.
State	Long	Describes whether the Command object is open or closed. Read-only.