Subject Re: [IBO] Pessimistic Lock
Author HJ
Geoff Worboys wrote:
> My main concern is your statement "dataset for updating totals", I
> hope this does not mean you are using triggers to maintain total
> records in some other table. This is not generally recommended and
> needs to be done very carefully to be safe in a multi-user
> environment.

Why ? What is the better way to update a total on another table ?
Because I have a lot of update like this in my application.