Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

CommandTypeEnum

Specifies how a command argument should be interpreted.

It is important to validate user-supplied CommandString values to avoid giving application users the opportunity to inject potentially dangerous commands for ADO to execute.

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.

When the type of command is not known, ADO will make several attempts to interpret the CommandText.

  • CommandText is interpreted as a textual definition of a command or stored procedure call. This is the same behavior as adCmdText.

  • CommandText is the name of a stored procedure. This is the same behavior as adCmdStoredProc.

  • CommandText is interpreted as the name of a table. All columns are returned by an internally generated SQL query. This is the same behavior as adCmdTable.

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.

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

Show:
© 2015 Microsoft