Data.Win.ADODB.TCommandType
Delphi
TCommandType = (cmdUnknown, cmdText, cmdTable, cmdStoredProc, cmdFile, cmdTableDirect);
C++
enum DECLSPEC_DENUM TCommandType : unsigned char { cmdUnknown, cmdText, cmdTable, cmdStoredProc, cmdFile, cmdTableDirect };
Properties
| Type | Visibility | Source | Unit | Parent |
|---|---|---|---|---|
| enum | public | Data.Win.ADODB.pas Data.Win.ADODB.hpp |
Data.Win.ADODB | Data.Win.ADODB |
Description
TCommandType values designate the type of a command.
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.