locked
DAAB RRS feed

  • 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,

    Sunday, November 25, 2012 2:10 AM

All replies

  • 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.

    Sunday, January 13, 2013 9:38 PM