>Is there a way to view all idx , etc.... associated with a table? I'm trying to clean a very old (2.6) and very large program and I'm not sure what indexes go to which tables. There have been way to many bandaids in this system and everything is everywhere...
>
>Thanks,
>Sunshine
Unfortunately, the information, what index belongs to what DBF, isn't stored anywhere in the files themselves (AFAIK). You would have to look in the programs, and search for commands like:
USE (table) INDEX (list)
USE (table)
SET INDEX TO (list)
FoxPro 2.0 already supported multiple indices in a single file (CDX), so it is a pity that the programmers didn't take advantage of this feature sooner.
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)