Home » RDBMS Server » Server Administration » Re: LAST_UPDATED attribute
Re: LAST_UPDATED attribute [message #373217] Wed, 04 April 2001 12:28
Andrew again...
Messages: 270
Registered: July 2000
Senior Member
You need to cater for it yourself. You can create "pre insert" trigger to maintain it. Consider tagging on a user_id field too. It's not comprehensive auditing and you need to take care of updates to records where no changes have been made. Some coders simply always update the DB record corresponding to an Edit screen whether and fileds have changed or not.

Report message to a moderator

Previous Topic: sql help
Next Topic: Cooment in Table
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Dec 23 05:19:04 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.