The TdDataAdapter.ContinueUpdateOnError is used to indicate whether the provider is to continue processing batches when an error is ecountered.

When set to true the Data Provider will continue processing the rows that are sent as batches when an error is encountered. The property DataRow.RowError of the row in the DataTable will be set to the error message. The application will have to scan rows contained in DataTableDataTable.Rows and inspect the properties:

The rows that were successfully processed will be applied to the database table that is associated with the DataTable. The exception to this occurs under the following scenario:

The TdConnectionStringBuilder.SessionMode is set to "Teradata".
An Explicit Transaction (TdTransaction) has been started.

When an error occurs under this scenario, the rows in the batches that have been successfully processed will be rolled back. The rows that were successfully processed in the batch that contains the error will be committed. The rows in batches that follow will be processed.

When ContinueUpdateOnError is set to false the Data Provider will stop processing batches when an error is encountered. The exception that was generated by the row that caused the error will be thrown from TdDataAdapter.Update.

The rows contained in batches that were processed before the error was encountered will be applied to the database table associated with the DataTable. Rows that were processed successfully in the batch that contained the error will also be applied to the table.

See Also