Re: Corrupt Table

On 13 Oct 1997 15:25:53 GMT, "Giles" <giles@meridian.co.za> wrote: >I have a table on SE where which at some stage a week ago corrupted. When I >query on the table on a date field I get a error stating that the date >field could not be converted. I have tried repair table which did not fix >the problem. I've also tried 'insert into new_table select * from >old_table` the corruption gets mapped onto the new table. I would like to >unload to table to a file, drop the table and then reload but I get the>conversion error when I try to unload. As a quick suggestion do this unload as you have before but select ROWID as one of the columns to unload, when the unload fails tail the unload file and the ROWID of the affected row should be apparent. now, update the date in the bad row, delete the row and re-add it or whatever you need to do to fix it...Hope this helps. > >I have also tried to locate the entry with the corruption in it but I have >had no luck as a select not connected with the date field works fine. Do not do a negated logic select to try to find the row...as you have experienced it likely won't work. > >Has anybody got any suggestions? > Hope this helps Mike South Producer/Director "Mike South's Southern Belles" "Mike South's Travels" Winner 1997 AVN Best Amateur Video Winner 1996 Rocky Mountain Oyster Readers Poll Best Pro-Am Series