Re: ODBC, NT and Workgroup problem

Walter S. Tyszka wrote: > The sugestion by Mr. Kagel to "SET LOCK MODE TO WAIT n" is one posible > solution. Another would be to "SET ISOLATION TO DIRTY READ". > Then the insert statement will be able to validate any unique constraint > violations. Not true. Isolation level has no effect on insert statements. There's no such thing as a "Dirty Insert". I don't know what you mean by "validate any unique constraint violations." > > > From: Jun Nolasco[SMTP:NOLASCO@INX.NET] > > > > > But, why is it that even with row level locking, these errors still > > occur eventhough no one else is currently using the record in question > > (but with others holding locks on other records)? And from the error > > messages, it looks like it is the index record that is locked, not the > > data record. What gives? I would suggest that you are running into different problems than the one described below. The error messages below distinctly suggest that it is NOT the index record that is locked. "Could not do a physical-order read" means it is doing a sequential scan. For starters, are you actually on OnLine 7.23? If you are having trouble inserting when other users are inserting, it sounds like Adjacent Key Locking, which was re-designed and eliminated in 6.0. > > > > asevillano@gesfor.es wrote: > > > > > > > > I have a problem in a NT 4.0 with INFORMIX Workgroup 7.23 and ODBC (Informix- > > > > > cli). When I insert a lot of records with a unique program there is no > > > > > problem, but when I execute several program at the same time begin to appear > > > > > those errors: > > > > > > > > -244: [INTERSOLV][ODBC Informix driver][Informix]Could not do a physical-order> > > > > read to fetch nect row. (S1000) > > > > > -243: [INTERSOLV][ODBC Informix driver][Informix]Could not position within a > > > > > table (%s). (S1000) and > > > > > -271: [INTERSOLV][ODBC Informix driver][Informix]Could not insert new row into > > > > > the table. (S1000) These are not all returning from the same program, are they? The first two do not sound like they could come from an Insert statement. June -- june_t@hotmail.com Grounded in Palo Alto, living on M&M's (peanut)