>Can someone tell me why it is that the indexes of tables sometimes get so corrupted that you have to delete the cdx file and add all of the indexes in again.
>
>Phil
Often because of a power failer (or the computer hangs), information might be partially written to the disk. This is aggravated by buffers for open files: information is not written to disk immediately.
Using the FLUSH command after making changes to each and every record (after TableUpdate(), if you use buffering) should reduce the corruption considerably.
HTH, Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)