Holden,

In form's Unload or container's destroy put FLUSH command.

HTH,
Regards,
Tomislav


>hi,
> Our application that is design from VFP6 always gets in trouble, ;
>It always down because the CDX file always corrupted. All users disappointed since the system in charge always reindex the application. As a developer,
>we are doing all our best to capture the reason but still the problem
>persist. My question is, (How/When/What the reasons) the file CDX gets corrupted ? and how to prevent it from getting the file from corrupted? We are only using Free Tables.
> thank you.
>
>
>holden