RAD Studio VCL Reference
ContentsIndex
PreviousUpNext
TInternalSQLDataSet.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) 2008 CodeGear(TM). All Rights Reserved.
What do you think about this topic? Send feedback!