Code: Select all
Write method : Upsert
Upsert mode: User defined update only
Update SQL: Write just an INSERT SQL statement instead on UPDATE statements
Moderators: chulett, rschirm, roy
Code: Select all
Write method : Upsert
Upsert mode: User defined update only
Update SQL: Write just an INSERT SQL statement instead on UPDATE statements
In an "ideal" case What you say would happen.vnspn wrote:Hi,
Yeah, I get your point, but...
If so see, there were previous replies in this same post that, the SQL in Update placeholder would get executed only if the SQL in Insert placeholder fails. As per this, in out case all incoming rows would get inserted through the Insert SQL and the Update SQL will not get executed for any row. Then, why should we explicitly give the where condition in the Update SQL as 0=1 , when the Update SQL is not at all going to get executed.
Thanks.