Re: Record Locking

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. Thus, when you read the table with no indexes present, a sequential scan gets executed so if *any* row in the table is locked, sooner or later you will encounter a lock error. (Remember, even if you are only looking for one row, Informix doesn't know for sure there is only one row matching your criteria so it has to carry on until it has processed the entire table, even if it has already found a hit). Better indexing is often the best solution to lock problems. akent@cix.compulink.co.uk (Andy Kent) ------------------------------------- 44 272 742815