Subject Re: [IBO] Pessimistic Lock
Author Luiz
----- Original Message -----
From: "Metin Gönen" <pentayaz@...>

> O.K Let me ask my question another way . I have a table which I need to
> sum it's two fields on every update , every insert , every delete. To make
> things faster I prepared a Master - Detail Dataset. I put the totals on
> master. Every time I update the child table I go to master table and
> the totals. Is there another way to do this ? like using a query every
> to get the totals of child fields , or using a SP or using a Trigger or
> something else ? Then what will be the advantages and disadvantages of
> these ?
> Metin Gonen
I have used this approach without problem in a application. I use triggers
and SP on child table to do this work. I didn´t have deadlocks untill now.