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.
cardoalex1
0 Points
4 Posts
DAAB
Nov 25, 2012 06:10 AM|LINK
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,
cnranasinghe
Star
8885 Points
1798 Posts
Re: DAAB
Jan 14, 2013 01:38 AM|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.