Re: SACEPREP/SACEGO 4.1

> I use SQL Development 4.1 on a Informix 5.0C?? Database. > My written ace-report runs very nice, but when there is a lock ... > Then it is as a roulette ... somtimes ace returned the same record (the > record, bevore the locked record) 1000 times. > > My Questions: > > Is it possible to set the lockmode to dirty read? No. You can set LOCK MODE to ROW or PAGE. You can SET ISOLATION TO DIRTY READ. (But neither of these is in Standard Engine, only OnLine.) This doesn't sound like it's your problem, though. > Are there any bugfixes of the problem below? > Other ideas? Have you checked your indexes (bcheck -y dbname.dbs/*.dat in SE, tbcheck -cDI in OnLine). HTH. -- Ciao, Billy +------------------------------------------------------------------------------+ | Billy Wheeler Junior Programmer / Director The West Solutions Group | +------------------------------------------------------------------------------+ | (E) billy@west.co.za (U) http://www.west.co.za/billy.html | +------------------------------------------------------------------------------+ | WARNING: sending me junk-email will be interpreted as granting permission to | | bomb your offices and machine-gun your children. | +------------------------------------------------------------------------------+