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.

HTH.

Regards, Norman.

----------------------------------------------------------------------------
----
Norman Dunbar EMail: Norman.Dunbar@...
Database/Unix administrator Phone: 0113 289 6265
Lynx Financial Systems Ltd. URL: http://www.Lynx-FS.com
----------------------------------------------------------------------------
----


-----Original Message-----
From: spou@... [mailto:spou@...]
Sent: Wednesday, September 12, 2001 4:01 PM
To: IBObjects@yahoogroups.com
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.
<SNIP>