Re: no change capabilty for a transaction

[<ke...@dk...>]

On Sun, Nov 04, 2001 at 12:35:49PM -0700, Dieter Simader wrote:
> Hi all,
> 
> I mentioned to Keld already that SL has the options available to close the
> books. Here is how you do that.
> 
> CREATE RULE acc_trans_delete AS ON DELETE TO acc_trans WHERE old.transdate
> <= 'date' DO INSTEAD NOTHING;
> CREATE RULE acc_trans_input AS ON INSERT TO acc_trans WHERE
> new.transdate <= 'date' DO INSTEAD NOTHING;
> 
> This will close the books up to the date you specify!

Good! Could it be built into SL? Normally the
accountant would not have access to run psql raw, so it would
be nice if it could be done from one of the SL screens.

Kind regards
keld