AW: [firebird-support] Foreign Key on update and after update trigger

2016-02-09 Thread 'checkmail' check_m...@satron.de [firebird-support]
Hello, is my question too complicated? Von: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] Gesendet: Freitag, 5. Februar 2016 12:27 An: firebird-support@yahoogroups.com Betreff: [firebird-support] Foreign Key on update and after update trigger Hello

Re: [firebird-support] Foreign Key on update and after update trigger

2016-02-09 Thread Svein Erling Tysvær setys...@gmail.com [firebird-support]
No, it does not seem difficult, Olaf. Assuming that twarehouse_sum contains some summation of twarehouse, I'd say the reason is as simple as two separate transactions modifying twarehouse simultaneously in a way that makes the change of the other transaction invisible. Generally, I'd say the idea

Re: [firebird-support] Foreign Key on update and after update trigger

2016-02-09 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
09.02.2016 13:16, Svein Erling Tysvær setys...@gmail.com [firebird-support] wrote: > Then you should have a separate process that at set times (e.g. once every > hour, day or > week), does something like: > > for select DistinctField, sum(MySummationField) from twarehouse_sum group by 1 >