RE: problem with lock of a record

How about: set isolation to dirty read;select record_from_table ... ; set isolation to committed read; delete from table where rec-id_key = record_from_table; Wayne E. Martin Informix Database Administrator Kmart Corp. -----Original Message----- From: Danny De Koster [mailto:ddk@fidelity-soft.be] Sent: Tuesday, January 09, 2001 12:11 PM To: informix-list@iiug.org Subject: problem with lock of a record Hi experts, When I want to use a table in which somebody has locked 1 row, the system answers that the record is locked. It seems to me incredible that there is no possibility to delete a record in a table when somebody else locks another record in that table. The system answers: 244: Could not do a physical-order read to fetch next row. 107: ISAM error: record is locked I have already done: alter table w_verklo lock mode (row) and: set lock mode to wait 5 I'm using INFORMIX OWS 7.31.UC6 Thanks for any solution. Danny