|Subject||Re: [firebird-support] master updation using trigger|
Alan McDonald wrote:
> for stock levels, always insert 1 for increment and -1 for decrement.Is it really needed if all the applications use snapshot transaction mode?
> housekeeping is a procedure which groups the sum of stocktype and replaces
> the starting balance with the value and deleting the increments and
> decrements. Then your system continues with inserting 1 and -1 again