Subject Re: [firebird-support] Re: Fwd: How to avoid deadlock ?
Author Vander Clock Stephane
> I don't get the point, sorry. If you perform SELECT in the same
> transaction as INSERT, then neither SELECT WITH LOCK nor UPDATE should
> wait. If the transactions are different, then both should wait. In this
> latter case, SELECT WITH LOCK will not wait only if you have already
> updated the record in the same (second) transaction, but again, the same
> applies to the regular UPDATE.

It's ok thanks it's was just my understanding of the With lock was not
too good. i just want to say that the select .... with lock work ONLY
if their is record returned by the select :) but it's evident :)

[Non-text portions of this message have been removed]