Class Command (ADODB VBA)

Defines a specific command that you intend to execute against a data source.

Methods

Cancel - Cancels execution of a pending, asynchronous method call.

CreateParameter - Creates a new Parameter object with the specified properties.

Execute - Executes the query, SQL statement, or stored procedure specified in the CommandText property.

Properties

Parameters (Default member) - Contains all the Parameter objects of a Command object.

CommandStream indicates the stream used as the input for a Command object.

CommandText indicates the text of a command to be issued against a provider.

CommandTimeout indicates how long to wait while executing a command before terminating the attempt and generating an error.

CommandType indicates the type of a Command object.

Dialect indicates the dialect of the CommandText or CommandStream properties. The dialect defines the syntax and general rules that the provider uses to parse the string or stream.

Name indicates the name of an object.

NamedParameters indicates whether parameter names should be passed to the provider.

Prepared indicates whether to save a compiled version of a command before execution.

Properties contains all the Property objects for a specific instance of an object.

State indicates for all applicable objects whether the state of the object is open or closed.

Parameter - Represents a parameter or argument associated with a Command object based on a parameterized query or stored procedure.

Parameters - Contains all the Parameter objects of a Command object.

Properties - Contains all the Property objects for a specific instance of an object.

Recordset - Represents the entire set of records from a base table or the results of an executed command. At any time, the Recordset object refers to only a single record within the set as the current record.