Re: timestamp update

See TFM, "Guide to SQL Syntax", where the index has an entry for "Update Statement and Triggers." TFM is available on the web site at http://www.informix.com . You might consider a separate table for update time tracking to avoid tracking the time that the timestamp was entered... ;) These issues are covered in the "Stored Procedures and Triggers" class, available on-site and at Informix Training centers worldwide. Clem At 12:10 PM 18-08-98 -0700, 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? > > /Erik > > > _____________________________________________________________ Clem Akins (aka clem@informix.com) Menlo Park x5937 Customer Course Development Informix Software, Inc Last seen: Riding the waves of a 5.3 California earthquake!