RE: Checkbook application

[Dieter S. <dsi...@sq...>]

A better way to keep track of what users do is to send all queries to a
separate table or log file. This provides you with a complete audit trail
and also a means to restore deleted transactions.


Dieter Simader    http://www.sql-ledger.org   (780) 472-8161
DWS Systems Inc.     Accounting Software       Fax: 478-5281
=========== On a clear disk you can seek forever ===========

On Tue, 25 Sep 2001, Jeff Kowalczyk wrote:

> [Dieter Simader] No new tables are required, I'll add a source and
> cleared field to the transaction table.
> 
> [jeff] Can I take this opportunity to suggest that the transaction table
> also include a column for 'posted' timestamp and 'postedby' user string.
> My original submitted patch included a second pair of 'updated' columns
> that I now realize were superfluous, but I do think that a single
> overwriteable timestamp/user pair per transaction is very useful and
> worth the space tradeoff. I have a need to track user responsibility for
> each transaction and time of entry.
>  
> I usually reapply this change to each new release, but it would be nice
> to get it into the source tree.
> 
> 
>