C.1.1- The Command Object

Created by Brendan Doss.
Last Updated by Brendan Doss.

Public Categorized as Appendix C.

Not yet tagged

<< C.1.0- The ADO Objects

C.1.10- The Property Object >>

The Command Object

Methods

Name	Returns	Description
Cancel		Cancels execution of a pending Execute or Open call.
CreateParameter	Parameter	Creates a new Parameter object.
Execute	Recordset	Executes the query, SQL statement or stored procedure specified in the CommandText property.

Properties

Name	Returns	Description
ActiveConnection	Variant	Indicates to which Connection object the command currently belongs.
CommandText	String	Contains the text of a command to be issued against a data provider.
CommandTimeout	Long	Indicates how long to wait, in seconds, while executing a command before terminating the command and generating an error. Default is 30.
CommandType	CommandType Enum	Indicates the type of Command object.
Name	String	Indicates the name of the Command object.
Parameters	Parameters	Contains all of the Parameter objects for a Command object.
Prepared	Boolean	Indicates whether or not to save a compiled version of a command before execution.
Properties	Properties	Contains all of the Property objects for a Command object.
State	Long	Describes whether the Command object is open or closed. Read-only.

<< C.1.0- The ADO Objects

C.1.10- The Property Object >>

Copyright © 2003 by Wiley Publishing, Inc.

Powered by Near-Time — Terms of Services | Privacy Policy | Security Policy |