Errors not detected when running [Insert before update]

Question

When I run [Insert before update] of a Table Write and get an error on insert, it ends up with 0 inserts and 0 updates and exits normally.
Why do both updates and inserts end normally with 0 inserts and 0 updates?

Answer

In [Insert before update] of a Table Write, the number of updates and inserts might be 0 when the following specification limitation is applicable
-------
When not updated with the UPDATE statement, the processing succeeds.
For instance, the case that an INSERT statement failed due to a cause other than key duplication applies.
-------
　　
-Specification
[Insert before update] executes an INSERT, and executes an UPDATE if the INSERT fails.
If an error occurs during the INSERT execution, the UPDATE is executed without outputting error information to the log, and it is considered to be a normal completion if the UPDATE is successful.
　
Please refer to the following manual for a description of this specification.
[Write Table] - [Difference between “Update before insert” and “Insert before update”]
https://www.hulft.com/help/en-us/HULFTSquare/Content/Designer/Connector/database_write_table.htm

If you would like to output errors that occur during INSERT, please use [Update before insert].