Last post Jan 13, 2013 09:38 PM by cnranasinghe
Nov 25, 2012 02:10 AM|cardoalex1|LINK
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.
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.
Jan 13, 2013 09:38 PM|cnranasinghe|LINK
remove the last_update column form insert trigger.
also it is better not to populate the last_update column on inserting. leave it blank.