Subject | Trigger for updating timestamp field? |
---|---|
Author | WEB ADMIN WEI |
Post date | 2007-02-22T14:47:35Z |
Hello,
I was wondering if it's possible to use trigger (or any other FB mechanism) to automatically update a value in a field of datatype TIMESTAMP?
I'd like to know when the given row was last updated, and am not sure if is necessary to create another log table, or can I update automatically the date-time value in a timestamp-type column?
For any help or suggestion thank you in advance.
[Non-text portions of this message have been removed]
I was wondering if it's possible to use trigger (or any other FB mechanism) to automatically update a value in a field of datatype TIMESTAMP?
I'd like to know when the given row was last updated, and am not sure if is necessary to create another log table, or can I update automatically the date-time value in a timestamp-type column?
For any help or suggestion thank you in advance.
[Non-text portions of this message have been removed]