>>>The Help files for PACK state that the command rebuilds all open index files. Is it safe to assume that .CDX files, open by definition, are re-indexed?
>>
>>John
>>
>>Yes, if associated with the packed Table then they are re-indexed. Memo files are also packed (they can get wild). Please not though the VFP indexes are not the same indexes your Mom & Dad used to use! VFP Tables now have backlinks in the header to the DBC, Primary index info is stored in the DBC, etc. To truly completely reindex you need a third party tool or do a lot of 'head banging'. It took me at least a week to write a routine. Learned a lot...
>
>if you are going to write such a thing
>look into the gendbc which can come handy for this
Arnon
Yes GenDBC is a corner stone of any true reindexing scheme. So is a Meta-Index file to store the info on the Indexes.
To be quite honest Stonefields Data package (forget the real name) may be best since could be a time consuminf and somewhat 'dangerous' process.
This is such an involved process that even ProMatrix contacted me on how I do it. After you learn it & do it it is not so bad but the process of doing it is not much fun.... At least it not almost a year ago when less was known about VFP.
HTH
Tom