Re: Strange Problem in In

What versions of what are running? I've seen something similar when a time was not specified on the lock wait SmartJaggu wrote: > > Hi all, > > I have a strange problem with informix. > I have two programs simultaneously accessing a table T. > T has row locking. > > program 1 : > =========== > set lock mode to wait;> begin work; > update row T.ROW in table T; > commit work; > > program 2 : > =========== > set lock mode to wait;> find all rows in table T ; /* actually in a cursor */ > > it seems that in output of program 2 ( that is in its cursor ) > row T.ROW does not get selected,if at that exact moment it's locked by > program 1. ( as if that row was not there in table T ) > > why is it happening ? how to avoid it ? and how can i simulate the > situation for testing ? could anyone advice ? > > Cheers, > Sandy. > > -- > Such is life and such is growing > And thru' mistakes, we end up in knowing !!! > > Sent via Deja.com http://www.deja.com/ > Before you buy. -- Paul Watson # WF Software # If it was easy Tel ++44 1436 674729 # Everybody could do it Fax ++44 1436 678693 # www.wfsoftware.com/informix #