Re: Which transaction isolation level can prevent lost updates?

Pablo,

thanks for your reply, and yes, this was a very simplified version of my real transaction just for making the lost update prob understandable. Unfortunately I cannot simply invoke one update...

Kind regards,
Arno Huetter

Pablo Sanchez <pablo_at_dev.null> wrote in message news:<Xns92D19CA953C5Apingottpingottbah_at_209.242.64.107>...
> Daniel Morgan <dmorgan_at_exesolutions.com> wrote in news:3DE2943C.B7201C05
> @exesolutions.com:
>
> // snip
> Being that the above is an example, the question is, can Arno re-write
> the query and embed the logic in the where clause of the update:
>
> trans 1: tran 2:
>
> update i=i+1
> update i=i+1
>
> now the work is atomic.
Received on Tue Nov 26 2002 - 00:27:26 CST