Subject RE: [IBO] a way to store "last accessed date"
Author Norman Dunbar
If this was something I had to do, I'd probably build it into a trigger
(insert and update) on the server.
After all, the server should do the work seeing as it should be/will be the
more powerful computer.
In addition, doing it on the server as a trigger will mean that any rows
inserted or updated via sql will also fire the trigger - if you did this in
the client application only, then it would be possible for a row to be
inserted or updated without getting the date stamp applied.


Regards, Norman.

Norman Dunbar EMail: Norman.Dunbar@...
Database/Unix administrator Phone: 0113 289 6265
Lynx Financial Systems Ltd. URL:

-----Original Message-----
From: spou@... [mailto:spou@...]
Sent: Wednesday, September 12, 2001 4:01 PM
Subject: [IBO] a way to store "last accessed date"

Hi there fellow IBO'ers

I am looking for a way to store, on each record of my table, the date
this record was last read.