Data window keyModification works with SQL Server trigger forupdate

Symptoms: when the keyModification update method in the data window is set to UseDeleteandinsert to update the data window, PB first generates the delete statement and then generates the insert statement for update. triggerforupdate is not performed because there is no update statement. trigger solution: when the key in the data window

Symptoms: when you select Use Delete and insert to update the key Modification update mode in the data window, PB generates the delete statement first and then the insert statement is generated for update because there is no update statement. therefore, trigger for update is not triggered. solution: when the key in the data window

Symptoms:

When you select Use Delete and insert to update the key Modification update method in the data window,

PB generates the delete statement and then the insert statement to update the statement. trigger for update is not triggered because no update statement exists.

Solution:

When the key Modification Update method in the data window is used to update the data window, an Update statement is generated.

Trigger