Events in Table

[Former Member]

Hi all,

My requirement is that when a record is entered in a table , another table (History table should be updated with the updation time/date and new n old values and a flag saying ADD or modify or delete )

I used event 02 for adding or modifying the event and 04 for deletion

But in deletion event after i make the required changes to history table, to save the changes back to the main table , I have to enter SAVE . Because of this SAVE , my records are getting duplicated (the records which are there in EXTRACT table )

I saw some similar posts in SDN but was not able to understand

Please help

Supriya

[Former Member]

Hi all,

My requirement is that when a record is entered in a table , another table (History table should be updated with the updation time/date and new n old values and a flag saying ADD or modify or delete )

I used event 02 for adding or modifying the event and 04 for deletion

But in deletion event after i make the required changes to history table, to save the changes back to the main table , I have to enter SAVE . Because of this SAVE , my records are getting duplicated (the records which are there in EXTRACT table )

I saw some similar posts in SDN but was not able to understand

Please help

Supriya

[Former Member]

Hi Supriya,

instead of going to two events, why cant you go to standard event AB(which is a standard routine) and it does everything you need it for the second table.