My sentiments too! Dennis McGrath
________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of [email protected] Sent: Friday, March 13, 2009 8:43 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: How to detect a dirty table? 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!
