Re: SQL to determine when a row was inserted/updated

Alex Fiore wrote: > > This is a situation that we had to solve for our systems. > All tables are created with two extra fields, one captures > the datetime when the row is updated/inserted and the > other captures the name of the user who last updated > the row. > > Then triggers are applied to the table to automatically > set this information on insert or update. On some tables > we have added a third column, a version number. This > gets set to 1 during an insert and incremented during > an update. > > Daniel Williams <danny@uk.ibm.com> wrote in article > <33B8FBAD.2781@uk.ibm.com>... > > Hi there! > > > > Is there some SQL that can be run to get a list of when rows were > > inserted into a table and also when they were updated? > > > > Dan Since insert triggers cannot affect the triggering table, this is not possible. (Is there some new version of Informix that fixes this limitation?) ----------- Roger Tomas AG Communication Systems