> You might want to get really creative and write a trigger
>to insert a row into a log table every time it your row is modified.
> I have never done this, but I can't think of a better use for a
> trigger.
I use this method with good results, in general. There is a big
(read _really big_) performance hit if you do an update that affects
a large number of records. In my case this is rarely an issue. Also;
it's a good idea to set a global var so the procedure attached to the
trigger can be suspended:
Set v CheckVar int = 1
Procedure
---------------
If CheckVar = 1 Then
do log update stuff
endif
Otherwise you can bloat your log table unintentionally
Ben Petersen
On 14 Feb 2002, at 9:53, Troy Sosamon wrote:
> With the computed columns in the table definition, the date & time stamps
> will update every time the record is changed regardless of who or what
> changed it. If you do bulk updates, the time stamps will change. I am not
> sure if a reload will update the timestamps or not.
>
> If you have a variable defined for everyone with their username or you could
> even use the network name from the cfg file w/ (cval('name')) and have a
> computed column that would pick that up also.
>
> You might want to get really creative and write a trigger to insert a row
> into a log table every time it your row is modified. I have never done
> this, but I can't think of a better use for a trigger.
>
> Troy
>
> ===== Original Message from [EMAIL PROTECTED] at 2/14/02 5:40 am
> >Computed columns in a table definition... Could it be that easy?!
> >I can't wait to try it...
> >
> >- Rob Vincent
> >
> >================================================
> >TO SEE MESSAGE POSTING GUIDELINES:
> >Send a plain text email to [EMAIL PROTECTED]
> >In the message body, put just two words: INTRO rbase-l
> >================================================
> >TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED]
> >In the message body, put just two words: UNSUBSCRIBE rbase-l
> >================================================
> >TO SEARCH ARCHIVES:
> >http://www.mail-archive.com/rbase-l%40sonetmail.com/
>
> ================================================
> TO SEE MESSAGE POSTING GUIDELINES:
> Send a plain text email to [EMAIL PROTECTED]
> In the message body, put just two words: INTRO rbase-l
> ================================================
> TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED]
> In the message body, put just two words: UNSUBSCRIBE rbase-l
> ================================================
> TO SEARCH ARCHIVES:
> http://www.mail-archive.com/rbase-l%40sonetmail.com/
>
================================================
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [EMAIL PROTECTED]
In the message body, put just two words: INTRO rbase-l
================================================
TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED]
In the message body, put just two words: UNSUBSCRIBE rbase-l
================================================
TO SEARCH ARCHIVES:
http://www.mail-archive.com/rbase-l%40sonetmail.com/
