Microsoft ActiveX Data ObjectsMicrosoft ActiveX Data Objects*
*Contents  *Index  *Topic Contents

CommandText Property - ADO

Contains the text of a command that you want to issue against a provider.

Applies To

Command

Settings and Return Values

Sets or returns a String value containing a provider command, such as an SQL statement, a table name, or a stored procedure call. Default is "" (zero-length string).

Remarks

Use the CommandText property to set or return the text of a Command object. Usually, this will be an SQL statement, but can also be any other type of command statement recognized by the provider, such as a stored procedure call. An SQL statement must be of the particular dialect or version supported by the provider’s query processor.

If the Prepared property of the Command object is set to True and the Command object is bound to an open connection when you set the CommandText property, ADO prepares the query (that is, a compiled form of the query is stored by the provider) when you call the Execute or Open methods.

Depending on the CommandType property setting, ADO may alter the CommandText property. You can read the CommandText property at any time to see the actual command text that ADO will use during execution.

Examples

ActiveConnection, CommandText, CommandTimeout, CommandType, Size, and Direction Properties Example (VB)


Up Top of Page
© 1997 Microsoft Corporation. All rights reserved. Terms of Use.