[RBASE-L] - Re: How to detect a dirty table?

[Doug Hamilton]

Well, thank you, you're most welcome Karen & Dennis.  And thanks again to Emmitt.
I'm just pleased that it's useful for others.
R:Fun forever!
Doug

Dennis McGrath wrote:

My sentiments too!

 

Dennis McGrath

 

---

From: rbase-l@rbase.com [mailto:rbase-l@rbase.com] On Behalf Of karentel...@cs.com
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!