A Command object is a definition of a specific command that you intend to execute against a data source.
Collections
Methods
Cancel, CreateParameter, Execute
Properties
ActiveConnection, CommandText, CommandTimeout, CommandType, Name, Prepared, State
Remarks
Use a Command object to query a database and return records (thereby creating a Recordset object), to execute a bulk operation, or to manipulate the structure of a database. Depending on the functionality of the provider, some Command collections, methods, or properties may generate an error when referenced.
With the collections, methods, and properties of a Command object, you can do the following:
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.
You can execute a Command simply by calling its Name property as a method on the associated Connection object. The Command must have its ActiveConnection property set to the Connection object. If the Command has parameters, pass values for them as arguments to the method.
See Also
© 1997 Microsoft Corporation. All rights reserved. Terms of Use.