RAD Studio VCL Reference
|
Indicates the meaning of the CommandText property.
property CommandType: TSQLCommandType;
__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. |
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!
|