How to find out which field in a table is updated

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

lphuong - 30 Apr 2004 14:32 GMT

When someone modifies a field in a table, I like to find out which
field he/she changed.
Currently, only the LAST person to modify an object is saved. For
example, if I modify an Application record, I will see "MyName" in the
"tblApplications.UpdatedBy" field and the date and time I updated it.
But it doesn't keep an historical record. We would like these changes
to be stored in a file or a table or something.
Please help

Reply to this Message

Todd Beaulieu - 30 Apr 2004 14:41 GMT

I don't know what the UpdatedBy field is that you're referring to. I assume
it's either an Access thing, or a custom field.

In SQL Server, if we need historical data, we would either put a Trigger on
the Table and have it add to a log table, or perform all updates through a
Stored Procedure, and have THAT log the history record. Either way, you must
have another Table to store this historical data.

You have but a single column storing a single value in your Table, so it can
not store multiple values.

A very long time ago, I once used a system wherein I rotated the last (some
number) update history in a single field, seperated by delimitters. That
actually worked fine for researching updates that didn't need to know WHAT
was changed, just WHO and WHEN.

> When someone modifies a field in a table, I like to find out which
> field he/she changed.
[quoted text clipped - 4 lines]
> to be stored in a file or a table or something.
> Please help

Reply to this Message

VB Forum / General 2 / April 2004

How to find out which field in a table is updated