I have an application written in VFP5 that I have 400 different agents using at their sites. I would like to create a utility to reindex the files better than I am currently giving them. Basically if the CDX file gets corrupt I would like to delete the CDX file and create a new one entirely. My original program I am using was pulled apart from a gendbc output. The problem is, I cannot recreate the entire tables because they have data that they need to keep.
This may be plain enough for you experts but I unfortunately am not. Any help on creating a new cdx file on an existing table would be appreciated. I also keep a newfile for the next key generator so I suppose I should check for accuracy on that in this program as well. Correct?