Am Using VFP5
Part 1:
When I issue VALIDATE DATABASE RECOVER, I get a message saying:
"The index tag MyIndex in the structural CDX of
table c:\...\data\MyTable was not found in the
DBC.
Would you like to add the index to the DBC,
delete the table object, or cancel the validation?"
Where is the VALIDATE DATABASE looking for this information? I've tried using the DBC as a table and searching through the Propery, code, ad user memo fields in records of the table but can't find any reference or cross references to the index.
Part 2:
What I've done is added an index to a table contained in a DBC via maintenance code in an EXE. I'm absolutely positive the DBC is opened exclusively, and positive the table is USED exclusively. I issue "INDEX ON student_id TAG student_id" and then close everything up.
In the command window, I can USE the table, and verify that the new index was programmatically added. I can even MODIFY DATA and see the same thing. But if I VALIDATE DATABASE, I get a message saying "Object ###. (Table 'MyTable'): One or more structural indexes missing from DBC."
Since I can't issue VALIDATE DATABASE RECOVER in code, I'm stumped as to what to do without rebuilding the whole mess.
A number of you have written and said what's explained in Part 2 "should work." I agree. It should. But how would you explain the fact that it's not?
Any help is really appreciated. This is quite confounding and has consumed way more time than I care to admit. Aside, what are the risks?
Thanks.
Ernie Veniegas
Micro System Solutions
... sensible software by design