Re: Locked record

In article <6s36ah$fbr$1@news.xmission.com>, "Marek Miloszewski" <marek.miloszewski@zes.szczecin.pl> wrote: > > Hi all, > > we have a problem with one of our application. Sometimes when somebody is > inserting new record into one of the tables, other person has a problem with > entering the application. Here is a message displayed: > > Program stopped at "function.4gl", line number 166. > SQL statement error number -244. > Could not do a physical-order read to fetch next row. > SYSTEM error number -107. > ISAM error: record is locked.> > The problem is that it does not happened continuously. One day yes, another > not. Our application producer said this is problem with our Informix > configuration. But other programs work properly! I don't know were to look > for error... > > Any suggestions? > Have you tried setting your lock mode to committed (or dirty) read, to see what affect it has? How about altering the lock level on the table to row instead of page? -mka -----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum