2.2.12. ADO Command object

Command object ¶

ADO Command object is used to perform a simple query oriented to the database. This query can perform actions such as create, add, retrieve, delete, or update records.

If the query is used to retrieve data, the data will be used as a RecordSet object returns. This means that the retrieved data can be retrieved RecordSet object’s properties, collections, methods, or events.

The Command main feature of the object is the ability to use stored queries and stored procedures with parameters.

ProgID ¶

set objCommand=Server.CreateObject("ADODB.command") 

Attribute ¶

Attribute	Description
`ActiveConnection`	Sets or returns a defined connection or the `Connection` string of the object.
`CommandText`	Sets or returns a string value that contains provider (provider) commands, such as SOL statements, table names, or stored procedure calls. The default value is “” (zero length string).
`CommandTimeout`	Sets or returns a long integer value that indicates the time, in seconds, towait for the command to execute. The default value is 30.
`CommandType`	Sets or returns a `Command` type of object
`Name`	Set or return the name of a `Command` object
`Prepared`	Indicates whether to save the compiled version of the command (the prepared version) before execution.
`State`	Returns a value that describes the `Command` object is open, closed, connected, executed, or retrieved data.

Method ¶

Method	Description
`Cancel`	Cancels an execution of a method.
`CreateParameter`	Create a new `Parameter` object
`Execute`	Execution `CommandText` a query, SQL statement, or stored procedure in the.

Set ¶

Set	Description
`Parameters`	All `Parameter` objects that contain a `Command` object.
`Properties`	All `Parameter` objects that contain a `Command` object.