Re: Strange error with date field (Online 5.01)

Douglas Wilson <dougw@amgen.com> wrote: DW: Try updating the date to a valid date with the between clause: DW: update edomorg set opdate="19.09.96" DW: where opdate between "19.09.96" and "20.09.96" DW: since they get selected, they should get updated(hopefully) The update failed with a similar error: 346: Could not update a row in the table 105: ISAM error: bad isam file format I also looked in the "online.log" file. There it says: 09:34:18 Rowid 0xc01 not found for delete in partnum 10000d8, key 1 09:34:18 7fffe488: 11098108 00000001 34de98e6 00050012 ........ 4....... 09:34:18 Run tbcheck -cI 16777432 09:34:18 -- Fail Consistency Check -- Delete failed -- pid=19591 user=104 us=11001ee8 The suggested "tbcheck -cI 16777432" returns no error. I am still clueless... Regards, Richard -- +----------------------------+-------------------------------------------+ | Dr. Richard Spitz | INTERNET: spitz@ana.med.uni-muenchen.de | | EDV-Gruppe Anaesthesie | Tel : +49-89-7095-3413 | | Klinikum Grosshadern | FAX : +49-89-7095-8886 | | 81366 Munich, Germany | | +----------------------------+-------------------------------------------+