common function to save various table data into history tables

[akapag22]

Hi friends,

I have two tables called t_customers, t_Items. Users can update them . Hence i I want to push the current record to a history table called th_customer and th_items respectively.
The th_ tables has all fields similar to the t_ tables except for a new field UpdateDone Field.

So is there a way i can use a common function where in I can pass the tablename and the curent date for the updateDone field .



The reason for this question is that i have 5 tables which have the history tables. I want to avoid writing 5 insert statements if they can be avoided.

Thank You

[Bob Fitz]

What is the need to move to a different table

[akapag22]

To keep track of what has been changed and at what date. SO before the update to a particular record, it is first saved to the history table.

[Bob Fitz]

So is there a way i can use a common function where in I can pass the tablename and the curent date for the updateDone field .

It should be possible to create a function which takes the date and the appropriate table name as arguments which can then be used in an input query statement to create the new record.