Re: Monitoring for Database Updates.

[Howard Weatherly <hweatherly@xxxxxxxxxxxx>]

Pat, 

When you set a trigger, it points to a trigger program which can do
whatever you want it to do, eg... log. You can have seperate programs
for each even, add, change and delete. If you use triggers you dont need
to worry about it, It just works!

Pat Barber wrote:
> 
> Colin Williams wrote:
> >
> > Is there any way to monitor for changes to a file, without using
> > journalling or triggers.
> 
> Prior to "trigger" days, I always wrote a small "logging" program
> that would kick in anytime the update occurred....Took a "snap shot"
> of entire record coming in, and then compared record at update time...
> I would write out the "before" & "after" record to my log file...
> 
> This was used mostly for debugging, but it would work for any other
> situation...
> +---
> | This is the Midrange System Mailing List!
> | To submit a new message, send your mail to MIDRANGE-L@midrange.com.
> | To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
> | To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner/operator: david@midrange.com
> +---
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---