The IDalCommandEx interface is used to work with database using SQL queries if an exception is thrown.
Use this interface methods to execute the command without clearing the counter of processed sets of parameter values. If errors occur at execution, use the SetCurrentParamsRow method to get the required set of parameter values and execute a separate command for this set only. Thus, a set of values can be determined that causes errors on executing the SQL query.
Method name | Brief description | |
ClearParamSets | The ClearParamSets method clears the counter of sets of parameter values in use. | |
ExecuteEx | The ExecuteEx method executes a command at the database server and returns the number of processed records. | |
ExecuteWithoutLastEx | The ExecuteWithoutLastEx method executes a command with all sets of parameters except for the last one and returns the number of processed records. | |
SetCurrentParamsRow | The SetCurrentParamsRow method determines the current set of parameter values. |
See also: