ADO: ActiveX Data Objects

Name

Command Object — (Versions 2.0, 2.1, 2.5, 2.6)

Synopsis

Dim object As ADODB.Command

The Command object executes a SQL statement, query, or stored procedure against a specified data source. A Command object can alter the structure of the data source, execute large batch operations, or select records to be returned within a Recordset object.

Collections

Parameters

The Parameters collection returns a collection of parameters for the given Command object.

Properties

The Properties property returns a Properties Collection class that contains characteristics specific to the Command object for the currently used provider.

Methods

Cancel

The Cancel method cancels the pending asynchronous command that is executing.

CreateParameter

The CreateParameter creates and returns a new parameter with the information that is supplied.

Execute

The Execute method executes a SQL statement, query, or stored procedure specified in the Command.CommandText property value.

Properties

ActiveConnection

The ActiveConnection property specifies the Connection object for the current Command object.

CommandStream

The CommandStream property sets or returns the data provider-specific stream that is used as the Command’s input just as the CommandText property identifies the command to use as the input.

CommandText

The CommandText property sets or returns a valid SQL statement, table name, stored procedure name, relative URL, or any other command text that the data provider may recognize.

CommandTimeout

The CommandTimeout property indicates ...