Command Object
A Command object is a definition of a specific command that you intend
to execute against a data source.
Collections
Parameters, Properties
Properties
ActiveConnection, CommandText,
CommandTimeout, CommandType,
Prepared
Methods
CreateParameter, Execute
Remarks
You can create a Command object independently of a previously defined Connection
object by setting its ActiveConnection
property to a valid connection string. ADO still creates a Connection
object, but it doesn't assign that object to an object variable. However,
if you are associating multiple Command objects with the same
connection, you should explicitly create and open a Connection object;
this assigns the Connection object to an object variable. If you do not
set the Command objects' ActiveConnection property to this
object variable, ADO creates a new Connection object for each Command
object, even if you use the same connection string.
Use Command objects to obtain records and create a Recordset
object, to execute a bulk operation, or to manipulate the structure of a
database. Depending on the functionality the provider exposes, some
collections, methods, or properties of a Command object may generate an
error when you call them.
With the collections, methods, and properties of a Command object, you
can do the following:
· Associate an open connection and the Command
object with the ActiveConnection property.
· Define the text version of the command
(for example, an SQL statement) with the CommandText
property.
· Set the number of seconds a provider
will wait for a command to execute with the CommandTimeout
property.
· Specify the type of command described in
the CommandText property with the CommandType
property prior to execution in order to optimize performance.
· Determine whether or not the provider
saves a prepared (or compiled) version of the command prior to execution with
the Prepared property.
· Manage command arguments passed to and
from the provider with the Parameters
collection.
· Execute a command and return a Recordset
object if appropriate with the Execute method.
See Also
Connection
| 
