In article <[EMAIL PROTECTED]>, Alex Turner <[EMAIL PROTECTED]> wrote:
% I really wasn't suggesting it be put in the table structure at the DB level, % more a sidebar suggestion for people building schemas for companies. I can't % count the number of times I've been asked when something was inserted and we % didn't have an answer for the question. Wouldn't it be nice for a change to % be _ahead_ of the game? Just sticking a time stamp on the row doesn't solve this problem, though, unless you preclude the possibility of the row being updated. Typically, someone wants to know when a particular field held a particular value, and you need an audit table for that. -- Patrick TJ McPhee North York Canada [EMAIL PROTECTED] ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]