The IDalCommand interface contains properties and methods that are used to work with database using SQL queries.
| Property name | Brief description | |
|
Connection | The Connection property returns the current database connection. |
|
CurrentParamsRow | The CurrentParamsRow property returns the index of the current set of parameters. |
|
InUse | The InUse property returns whether the SQL query is executed on the database at the moment. |
|
MaxParamsRows | The MaxParamsRows property determines the maximum number of processed sets of parameter values. |
|
Params | The Params property returns SQL query parameters. |
|
SQL | The SQL property determines a line (SQL query) that must be executed at the database server. |
|
Type | The Type property determines a type of executed command. |
| Method name | Brief description | |
 |
Close | The Close method closes SQL query and releases operating system resources. |
|
CreateCursor | The CreateCursor method creates a cursor that is used to move through data obtained by executing SQL query to database. |
|
DescribeCursor | The DescribeCursor method creates a cursor that contains only data fields. |
|
Execute | The Execute method executes the command at the database server and returns the number of processed records. |
|
ExecuteWithoutLast | The ExecuteWithoutLast method executes the command with all sets of parameters except for the last one and returns the number of processed records. |
|
NextParamsRow | The NextParamsRow method saves the current set of parameters and moves to the next one. |
|
Parse | The Parse method analyzes a string, detects operators, conditions and parameters. After analyzing the compiler knows which conditions are used in the SQL query, the number of parameters, and so on. |
|
Prepare | The Prepare method prepares a command for the repeated use at the database server. |
|
Unprepare | The Unprepare method cancels the effect of the Prepare method. The method is under development. |
See also: