Due a problem, I need to do something to dbf file.
I managed to read the original dbf file, and then copy down some selected records into another dbf file, thus renaming it to replace the old dbf file.
As it seems there's no problem, but I just found out that the index are messed up, so some records aren't shown.
The original dbf file was accompanied by cdx as index though there's no indexing appeared when I open it with Visual Foxpro or alike (there are only list of fields), as far as I know this sort of index is automatically generated...so my guess is I need to regenerate the cdx file.

I wonder if this can be done by Java or should I refer to old foxpro/clipper for this.


Thanks in advance.
FYI : the cdx and dbf share the same file name.