ExecuteWithoutLastEx(ClearParamSetsOnError: Boolean): Integer;
ClearParamSetsOnError. The parameter that determines whether the counter of the processed sets of parameter values is to be cleared after running this method.
The ExecuteWithoutLastEx method executes a command with all sets of parameters except the last one and returns the number of processed records.
If the True value is passed as the ClearParamSetsOnError parameter, this method works the same as the IDalCommand.Execute method.
If the ClearParamSetsOnError property is set to False, after executing this method, the counter of processed sets of parameter values available in the IDalCommand.CurrentParamsRow property is not cleared. If during the command runtime errors occur, get the IDalCommand.CurrentParamsRow value to find out how many sets were processed. Use the SetCurrentParamsRow method to go through the parameter sets and run a separate command with the selected values. Thus a set of values can be defined that causes the SQL query runtime error.
The example of running the command without clearing the counter of used parameter values is given in the example of the ExecuteEx method.
See also: