Error handling settings allow you to configure SQL execution, concurrency check, and error handling.
Show SQL
Select this check box to see the generated SQL query when committing changes.
SQL execution confirmation
Select this check box if you want to see a dialog box asking you to confirm or cancel committing changes.
Close SQL preview dialog if no errors or warnings
Select this check box if you want the SQL preview dialog box to be closed when you click the Execute button and there are no errors or warnings during execution.
Use concurrency check for UPDATE command generation
Select this check box to make the add-in to check whether no-one else has committed changes of the same data before you do.
Only for relational databases (like SQL Server, MySQL, etc.)
If you don't want to check for concurrent changes in cloud data sources, select this check box.
Use transaction (if data source supports transactions)
If your data source supports the transactions mechanism, Devart Excel Add-ins will warn you if any errors are detected while committing changes.
Rollback after failed concurrency check
If concurrent changes to the same data are detected, your changes will be rolled back.
Stop commit after first error
If any errors are detected while committing, you will get a warning on the first detected error, and your changes won't be committed after this.
Stop commit after first failed concurrency check
If concurrent changes to the same data are detected, your changes won't be committed after the first detected concurrency change.
Show commit error message
If an error occurs during commit, a message box is displayed with the error message.