Hi Elein; Nope, OLD is correct. I track the OLD values and then use the view to combine those with the current ones. This allows the OLAP portions of the code to hit against *all* the data, while archiving old, outdated information in the archive table. It also allows deleted tuples to be tracked with the same trigger since a deleted row doesn't exactly have a NEW tuple :-) Maybe you misunderstand what I am trying to do?
Best WIshes, Chris Travers ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
