DAAB

Question

User1073919730 posted

Hello,

I have successfully implemented DAAB which does the Inserts and Updates on the data. But, I am facing following issue

The table onto which the DAAB is working, has got a trigger defined on it. The trigger fires when an Insert/Update happens on that table. The table has a column called "LAST_UPDATE" which stores the datetime entry. For a particular row, when the Insert happens, datetime entry is stored there. When the Update happens, that particular datetime is stored. This all happens by the way of trigger.

Problem:

Even if I suppy the same values for a particular value, the trigger is getting fired and LAST_UPDATE is getting updated. I want to avoid this anyhow. Pls suggest a.s.ap.

Thanks,

Answer 1

User-37275327 posted

remove the last_update column form insert trigger.

also it is better not to populate the last_update column on inserting. leave it blank.