Post reply

update history capture

  • January 20, 2011 at 8:48 pm

    #104028

    Dear Experts,

    I have the following table structure

    ID int primary key

    date_modified datetime

    firstname varchar(10)

    last name varchar(10)

    address1 varchar(10)

    addrsss2 varchar(10)

    comments varchar(50)

    Through the front end application user can modify any of the fields in the above table.

    I need to capture what are all the fields edited in the last one week.

    How do do this.? Your help highly appreciated.

    We don't have any history table to capture or any audit as such.

    Any Ideas how do we get this ?

  • January 20, 2011 at 10:05 pm

    #1276372

    Not sure you can get what you want without capturing the history of the changes. You need to capture the changes as they occur in a history table of some sort.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply