Last Modified Date

[oortiz]

Hi,


I need a field with the last modified datetime for a recno,
may be with a update trigger?

thanks,

O.

ps: mi english is poor.

 

[baltman]

How will a user be modifying the table? What environment are you working in?

 

[Mike Gagnon]

oortiz

Create an exra field (Datetime) and everytime the user modifies the record, record the datetime value in that field. Mike Gagnon

If you want to get the best response to a question, please check out FAQ184-2483 first.

 

[rgbean]

Note, you'll have to do this programmatically, as an update trigger CAN'T update the current record. If it did, you'd essentially get a non-terminating looping condition. Normally you'd write update info in a separate log file in a trigger method.

Rick