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 |
|---|---|
| Sets or returns a defined connection or the |
| 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). |
| Sets or returns a long integer value that indicates the time, in seconds, towait for the command to execute. The default value is 30. |
| Sets or returns a |
| Set or return the name of a |
| Indicates whether to save the compiled version of the command (the prepared version) before execution. |
| Returns a value that describes the |
Method ¶
Method | Description |
|---|---|
| Cancels an execution of a method. |
| Create a new |
| Execution |
Set ¶
Set | Description |
|---|---|
| All |
| All |