CommandTypeEnum

Applies to: Access 2013, Office 2013

Specifies how a command argument should be interpreted.

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.

ADO/WFC equivalent

Package: com.ms.wfc.data

Constant

AdoEnums.CommandType.UNSPECIFIED

AdoEnums.CommandType.TEXT

AdoEnums.CommandType.TABLE

AdoEnums.CommandType.STOREDPROC

AdoEnums.CommandType.UNKNOWN

AdoEnums.CommandType.FILE

AdoEnums.CommandType.TABLEDIRECT