The IDalCommand interface contains properties and methods used to work with the database using the SQL queries.
| Property name | Brief description | |
| Connection | The Connection property returns a reference on the IDalConnection interface that controls 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 parameters of the SQL query. | |
| SQL | The SQL property determines a line (SQL query) that must be executed on the database server. | |
| Type | The Type property determines a type of the command to be executed. |
| Method name | Brief description | |
| Close | The Close method closes SQL query without releasing storage reserved for it. | |
| CreateCursor | The CreateCursor method creates cursor that enables user to navigate through data received executing SQL query to the database. On creating the cursor the Execute method is executed automatically. | |
| DescribeCursor | The DescribeCursor method creates a cursor that contains only data fields. | |
| Execute | The Execute method executes the command on the database server and returns the number of processed records. | |
| ExecuteWithoutLast | The ExecuteWithoutLast method executes the command with all sets of parameters except the last one and returns the number of processed records. | |
| NextParamsRow | The NextParamsRow method saves the current set of parameters and passes to the next one. | |
| Parse | The Parse method analyzes a string, detects operators, conditions and parameters. After analyzing the compiler knows which conditions take part in the SQL query, the number of parameters and so on. | |
| Prepare | The Prepare method prepares a command for the repeated use on the database server. | |
| Unprepare | The Unprepare method cancels functioning of the Prepare method. This method is under development. |
See also: