Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post Jan 14, 2013 01:38 AM by cnranasinghe
Nov 25, 2012 06:10 AM|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 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.