Data.SqlExpr.TCustomSQLDataSet.CommandType

• Up to Parent: TCustomSQLDataSet

[–] Properties Type: property Visibility: protected Source:

Data.SqlExpr.pas

Data.SqlExpr.hpp

Unit: Data.SqlExpr Parent: TCustomSQLDataSet

Delphi

property CommandType: TSQLCommandType read FCommandType write SetCommandType default ctQuery;

C++

__property Data::Db::TSQLCommandType CommandType = {read=FCommandType, write=SetCommandType, default=1};

Description

Indicates the meaning of the CommandText property.

CommandType indicates the type of command that is contained in the CommandText property. TCustomSQLDataSet descendants set this value to the way in which they specify a query or stored procedure.

The following table lists the possible values:

CommandType	Corresponding CommandText
ctQuery	An SQL statement that the dataset executes.
ctStoredProc	The name of a stored procedure.
ctTable	The name of a table on the database server. The SQL dataset automatically generates a SELECT statement to fetch all the records on all the fields in this table.

See Also

• CommandText

• Setting Up a Simple Dataset

• Representing the Records in a Table

• Representing the Results of a Query

• Representing the Results of a Stored Procedure

• Specifying the Command to Execute

• Specifying What Data to Display

• Executing the Commands using TSQLDataSet

• Specifying the Data to Display using TSQLDataSet

• Using TSimpleDataSet