Pls help with this Trigger problem. :0

I have a table name called customer and i would like to keep track on which column it has updated using trigger.

For example;

cust_id, cust_name,cust_addr,cust_phone,cust_country.

When I update the cust_name and cust_addr, I am thinking of inserting into a log table with 2 seperate records as shown below

cust_id, cust_name
cust_id, cust_addr.

Table (Customer) is just a single table and i am planning to apply the same logic on 50+ more tables.

Is there a easier way ..??? Pls help.

Richard Received on Sun Feb 13 2000 - 21:30:32 CST