locking

Hi, We have a 4GL program whenever it runs it will lock several tables. The problem is that the lock will remain long enough more than the deadlock timeout parameter. Why? and the other ppl's work will be locked as well. The isolation level is set to repeated read, is that appropriate? Regards, Nien =========================================== Mails are checked daily and processed right away. If you don't get my replies within 3 days please send your mail again.