RAD Studio VCL Reference
ContentsIndex
PreviousUpNext
TCustomSQLDataSet.CommandType Property

Indicates the meaning of the CommandText property.

Pascal
property CommandType: TSQLCommandType;
C++
__property TSQLCommandType CommandType;

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.  

 

Copyright(C) 2009 Embarcadero Technologies, Inc. All Rights Reserved.
What do you think about this topic? Send feedback!