|
RAD Studio VCL Reference
|
  |
   |
TInternalSQLDataSet.CommandType Property
|
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!
|
Description