Subject Re: [firebird-support] master updation using trigger
Author Milan Babuskov
Alan McDonald wrote:
> for stock levels, always insert 1 for increment and -1 for decrement.
> 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

Is it really needed if all the applications use snapshot transaction mode?

Milan Babuskov