ADODB.TCommandType Enumeration

TCommandType values designate the type of a command.

Pascal

TCommandType = (
  cmdUnknown,
  cmdText,
  cmdTable,
  cmdStoredProc,
  cmdFile,
  cmdTableDirect
);

C++

enum TCommandType {
  cmdUnknown,
  cmdText,
  cmdTable,
  cmdStoredProc,
  cmdFile,
  cmdTableDirect
};

File

ADODB

Description

Use TCommandType values to specify the type for a command contained in the CommandText property of an ADO component capable of issuing commands.

The constants that make up the TCommandType type correspond directly to the ADO CommandTypeEnum constants. These constants are used in the CommandType property of ADO Command objects. For additional information on these ADO constants and their effects, see the Microsoft Data Access SDK help in the topic for the CommandType property of the ADO Command object.

TCommandType consists of the seven constants summarized in the following table:

Command type	Meaning
cmdUnknown	The type of command in the CommandText property is not known.
cmdText	CommandText is a textual definition of a command or stored procedure call; data returned by an internal SQL statement.
cmdTable	CommandText is the name of a table.
cmdStoredProc	CommandText is the name of a stored procedure.
cmdFile	CommandText is the name of a saved recordset file.
cmdTableDirect	CommandText is the name of a table; all columns are returned.

Note: The TCommandType constants cmdTable, cmdTableDirect, and cmdOpenFile are not for use with commands executed from a TADOCommand component.