ADO: ActiveX Data Objects

Name

CommandTypeEnum Enumeration — (Versions 2.0, 2.1, 2.5, 2.6)

Synopsis

The CommandTypeEnum enumeration indicates how a command argument should be interpreted.

Table E-7. CommandTypeEnum Enumeration Values

Enumeration (ADO/WFC)	Value	Description
adCmdFile (FILE)	256 (&H100)	Indicates that the CommandText property should be evaluated as a name of a file that contains a persisted recordset.
adCmdStoredProc (STOREDPROC)	4	Indicates that the CommandText property should be evaluated as a stored-procedure name.
adCmdTable (TABLE)	2	Indicates that the CommandText property should be evaluated as a table name. This table name will be converted to a SQL statement by ADO to return all of its columns.
adCmdTableDirect (TABLEDIRECT)	512 (&H200)	Indicates that the CommandText property should be evaluated as a table name.
adCmdText (TEXT)	1	Default. Indicates that the CommandText property should be evaluated as a SQL statement or a data provider-specific command (including a stream).
adCmdUnknown (UNKNOWN)	8	Indicates that the type of the CommandText property is not specified.

ADO/WFC

The CommandTypeEnum enumeration is part of the com.ms.wfc.data package, and the constant values are preceded with AdoEnums.CommandType.

See Also

Command.CommandStream Property, Command.CommandType Property, Command.Execute Method, Connection.Execute Method, Recordset.Open Method, Recordset.Seek Method