Data.Win.ADODB.TCommandType

From RAD Studio API Documentation
Jump to: navigation, search

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.

See Also