Re: row level locking and dead-lock prevention

Andy Kent writes: |> |> Another thing worth bearing in mind here is that if you've SET LOCK MODE |> TO WAIT n (where n is a number of seconds), you get the "deadlock" error |> if it times out. So in fact you may not have a *real* deadlock at all. This is not true. A "*real*" deadlock will return an isam error of -143. A lock timeout will return -154. There should never be any question as to whether or not you have a "*real*" deadlock. Dave Kosenko Disclaimer: All opinions expressed in this message are well-reasoned and insightful; needless to say, they are not those of Informix Software, its partners or lackeys. Anyone who says otherwise is itching for a fight. **************************************************************************** "I look back with some satisfaction on what an idiot I was when I was 25, but when I do that, I'm assuming I'm no longer an idiot." - Andy Rooney