Re: I'm looking for FAQ!

Posted in 1995

Spokey the Wheeler — Sat, 16 Sep 95 22:53:46 GMT — source: Informix-list mailing list archive (1991-1998)

In article <43ek85$i8n@sun1000.ci.pwr.wroc.pl> biprogeo@sun1000.ci.pwr.wroc.pl "BIPROGEO" writes (somewhat cryptically): > Help me!! > I'm starting 4GL programming and I have several problems with > My problem is: > I have LOCK MODE COMMITED READ. > User X1 doing UPDATE without COMMIT. > User X2 can't do any SELECT on this table. > Why? How can I solve this problem.??? COMMITTED READ is an ISOLATION LEVEL, not a LOCK MODE. A more complete code sample would help. Error numbers would help. At what point do you get the error: at the start of the read or in the middle? BTW, are you using PAGE level or ROW level locking. (Big hint! :-) Look forward to hearing more! Cheers, Spokey the Wheeler------------------------------------------------------------- "Billy Boy" - das aufregend andere kondom! Carter - the Unstoppable Sex Machine / Wheeler - the Unstoppable Mail Machine!