Re: timestamp update

Erik Nis Jessen wrote: > > In one of our table we want to keep track of changes by adding a > timestamp whenever the table changes. > The table is created with: > k_lastupdated DATETIME YEAR TO FRACTION DEFAULT CURRENT > which correctly insert a timestamp when the table is created. > Can someone direct me to literacy or have a good idea as to what I need to > do to update this timestamp when UPDATE queries are perfomed on the > table? Add an UPDATE trigger to update the timestamp column. Art S. Kagel