>Yikes, a new requirement.
>
>Each table needs columns:
>LastUpdatedBy (both domain users and web users (username in db))
>LastUpdatedDate
>
>Anyone implemented something like this, gathering user info in a business object save override?
>
>[Edited]
>With more thinking, it seems that the best place to set UpdatedBy stuff is in business rule code...
>Add a current user property to business object...
>Pass current user name to business object constructor...
>
>[Edited]
>Then again, Stephen Russell, in a 2004 post, checks for altered records in the dataset...
>
http://www.levelextreme.com/wconnect/wc.dll?2,15,887603>Same as Carl Olson in
>
http://www.levelextreme.com/wconnect/wc.dll?2,15,896730I had to keep all former changes to the data in a log environment so a supervisor could see who made a change and when. These were intricate parts and assemblies and the management wanted to know who made a change, and why.
So I had to capture if a coulmn was different, and if so old / new value, who and when.
You can make this easier for your needs. Have a column for last editor and update that as needed in the biz object for every table. Next put a trigger in the table for update and set the EditDate in the trigger.
Yours is a simple request.