Re: Record Locking

> Andy Kent writes: > |> My guess is that you are falling foul of the 'feature' whereby > lock > |> testing is applied to every row *touched* rather than every row > brought > |> into the program. > Possible, but rather unlikely. For this to occur, you'd have to > be using an isolation level of repeatable read, which means > you've set it to that and as such I would assume you knew the > dangers involved. I don't have the original discussion readily to hand, but if you are talking about U or X locks, then contention is liable to occur on any row touched, regardless of isolation level. Isolation levels only apply to things you're reading. akent@cix.compulink.co.uk (Andy Kent) ------------------------------------- 44 272 742815