>Hi All,
>I had a question posed to me by the boss the other day. He still uses FoxBase+ and has to reindex tables frequently. He is under the impression that the same occurs with VFP. I told him it doesn't. He wants to make sure that if I am ran over by a bus that he can reindex everything with the touch of a button. I told him he can't, it's a little more complicated than that. Is there something in Stonefield that helps with rebuilding indexes if one gets corrupt?
>TIA,
FoxBase, and FoxPro 1, use single-index files. These files (IDX in FoxPro) have to be explicitly opened together with the DBF.
FoxPro 2 and later also support multi-index files. The old syntax (for single-index files) is:
index on MyField to MyTable1
The new syntax:
index on MyField tag MyField
If you use the new syntax, the indices are opened automatically, every time you use the table. Therefore, it is not possible that indices created this way don't become updated through a programming error (omitting to open the index explicitly). Indices can still become corrupted, though.
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)