Subject Re: [firebird-support] Re: IS this the right thing to do (trigger)
Author Alexandre Benson Smith
Robert martin wrote:
> I assume this is safe only if run in a snapshot (forget the phrase)
> transaction, otherwise entries added while the SP is running might get
> deleted but not summed?
>
> Will look at implementation !
>
> Love the solution
> Rob
>

According to some people anything besides snapshot is just not
"isolation level" :)

I think reports or other long running "analytical" (don't find a better
word for it) queries are very good candidates for snapshot transactions.

see you !

--
Alexandre Benson Smith
Development
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br