Re: isql detail table update?

In article <753287674snz@ipaedin.demon.co.uk>, Malcolm McLean <Mmclean@ipaedin.demon.co.uk> wrote: >In article <CGGnwp.4G5@perk.jpr.com> news@perk.jpr.com writes: > >Try this:- > >update atkliqud > set unit_type = "Sludge" > where atkliqud.tk_num in ( > select > atkliquh.tk_num from atkliquh > where atkliquh.job_num = 100 > ); > >-- Your query works me if only a few records are updated. In a case where a few thousand records are updated I get the following isql runtime errors: Sometimes: 346:Could not update a row in the table 121:ISAM error: could not write log record Othertimes: Fatal system error: ignoring modifying buffer 408: Invalid message type received from sqlexec process. I think these errors are OS kernel related. Were running SCO ODT 3.0. I tried bumping the FLCKRECS up to 300 from 100 and that did not make a difference. Any other ideas? -- Unix at Home perk machine Joseph A. Miele jam@perk.jpr.com Dir MIS Spectraserv, Inc. 76207.1365@compuserve.com