>Hello very body,
>
>I have problem with CDX files. When my program run and users entering the data some time if powers fail, my CDX files come corrupt. Only one method which I know is remove table from database and delete CDX file and add return table in database and generate index tag.
>
>Please tell me solution, if any procedure or function which able automatically solve my problem
>
>
>Thank You
One thing you should definitely do is try to avoid data corruption in the first place. To avoid having data in buffers (that is, buffers at the operating system level), issue a FLUSH after you change each record. This can greatly reduce (but not eliminate completely) data corruption, and especially index corruption.
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)