Re: DateTime when a Record has changed ?

From: atl.mediaone <rmycroft_at_mediaone.net>
Date: Mon, 11 Sep 2000 10:25:56 GMT
Message-ID: <Uq2v5.29941$gg.7720011@typhoon.southeast.rr.com>

Or how about a trigger to write a record to another table? Think he already stated he cannot change the table structure, but he should be able to add a new table.

Rich

NIKHIL N. TALATI wrote in message <39BC58E8.FE0A301F_at_hotmail.com>...
>You can write triggers on the table to update additional columns placed in
>the table to
>get data/time or user which changed the record
>
>Mika wrote:
>
>> Is there a way to get the Date/Time when a Record has changed last.
>> Or is there an other identifier to find out if a Record has been changed
>> by an other user ?
>>
>> Thanx for an answer
>
Received on Mon Sep 11 2000 - 05:25:56 CDT