>Hello everybody,
> I just had a case of a corrupted index. I have a table with around
> 250,000 records and close to 400 mb, I had to move almost half
> of the data to a different place after I moved the data I deleted
> the records from the table without packing it, a few days later ,
> records started to "dissapear", well, I found that the index was
> corrupted, I deleted the index and created again, guess what ?,
> we lost 10,000 records !!. Does anybody have any clue why this happened ?. Have somebody had a similar experience ?
> Any suggestion is welcome.
> Thanks in advance.
Hi Luis:
I noticed no one had responded, so here's my try...
My guess has to do with the deleted records and the setting of DELETED = ON or OFF. If you had DELETED ON and used VFP to copy/move the data to 'different place' (ie: USE xxx/COPY TO yyy), only the non-deleted records would be copied into the new table/location. Wouldn't that be what was desired when deleting records? Or are you just trying to 'hide' them? Are you sure the index was really corrupted and if so, how did you establish that fact? What do you mean by 'lost 10,000 records' -- is the record count now 10,000 less, or was a 'COUNT' operation showing 10k less than expected?
HTH
Rob
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only