RAD Studio VCL Reference
ContentsIndex
PreviousUpNext
TSQLDataSet.CommandType Property
TSQLDataSet Class | TSQLDataSet Members | SqlExpr Namespace | Description | See Also
Collapse All

Command type of CommandText property.

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

CommandType indicates the command type of the CommandText property.  

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.  

Note: Changing CommandType automatically changes the DbxCommandType property and vice versa. The additional settings supported by DbxCommandType are converted to ctQuery for CommandType.
 

See Also
Copyright(C) 2008 CodeGear(TM). All Rights Reserved.
What do you think about this topic? Send feedback!