Re: "Cannot write log record..." :((((((((

In article <DBLr5D.LJD@cix.compulink.co.uk>, tbone@cix.compulink.co.uk ("Chris Totten") says: > > >> Date: 12/07/1995 Time: 10:23:36 >> Program error at "custom.4gl", line number 225. >> SQL statement error number -346. >> Could not update a row in the table. >> SYSTEM error number -121. >> ISAM error: cannot write log record> >I'm getting this error message whenever I try to carry out the following >(simple) SQL update command. The command is part of a 4GL program, but it >falls over even I try to do the update from ISQL... :( > >update stamtana ", > set area_code = "C2" > where cust_no = "XXXX" > It may be that for the value of "XXXX" and given that you have many rows in the table, that you are creating too large a transaction. Try locking the whole table first ( lock table stamtana in exclusive mode), then run the update. If this doesn't work, how about dropping the indexes and trying the update with no indexes.