ADO CommandType Property

The CommandType property sets or returns a CommandTypeEnum value that defines the type of the Command object. Default is adCmdUnknown.

If you do not specify the type, ADO will need to contact the provider to determine the type of the command. However, if you do specify the type, ADO will be able to process the command faster.

Syntax

objcommand.CommandType

Example

Dim objCommand As ADODB.Command

Set objCommand = New ADODB.Command
Set objCommand.ActiveConnection = strConnection
objCommand.CommandType = adCmdText OR adExecuteNoRecords

CommandTypeEnum Values

Constant	Value	Description
adCmdUnspecified	-1	Does not specify the command type argument.
adCmdText	1	Evaluates CommandText as a textual definition of a command or stored procedure call.
adCmdTable	2	Evaluates CommandText as a table name whose columns are all returned by an internally generated SQL query.
adCmdStoredProc	4	Evaluates CommandText as a stored procedure name.
adCmdUnknown	8	Default. Indicates that the type of command in the CommandText property is not known.
adCmdFile	256	Evaluates CommandText as the file name of a persistently stored Recordset. Used with Recordset.Open or Requery only.
adCmdTableDirect	512	Evaluates CommandText as a table name whose columns are all returned. Used with Recordset.Open or Requery only. To use the Seek method, the Recordset must be opened with adCmdTableDirect. This value cannot be combined with the ExecuteOptionEnum value adAsyncExecute.