Doug: Cool! For years I've considered that column useless, and would usually set it permanently off. Never considered turning it on and off to track whether changes are made to a temp table. I'm glad you brought it up because I never would have thought of it on my own!
Karen > Bingo Karen! And it isn't as complicated (for my needs) as you suggested. > > SYS_ROWVER basically does what Emmitt suggested with triggers but all the > heavy lifting is done by R:Base: it adds the SYS_ROWVER column, sets it to 1 > for all rows, creates the trigger and increments SYS_ROWVER each time a col > in > a row is changed. So any changed row will have a SYS_ROWVER value >1, I don't > even need to compare it to the original table. woohoo!
