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/
