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

CommandText 

DbxCommandType 

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

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