Skip to Content
0
Former Member
Sep 19, 2005 at 02:12 PM

Database table update

15 Views

Hi All,

I have a table say A, i have a lot of entries in it& has been used in several pgms.

now i hav to create a table B and if any row in table A is modified, B should contain the Old & new value of that row.

now the logic for copying the modified row is done.

but i want to schedule the program only when table A is accessed by any of the pgm's. is there any way to do it.

Regards

Raghavendra