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