Tags: database, delete, error, file, foxpro, index, match, microsoft, mysql, oracle, re-create, recovered, recreate, sql, table

Index does not match the table. Delete the index file and re-create the index (Error 114)

On Database » Microsoft FoxPro

726 words with 2 Comments; publish: Sun, 16 Dec 2007 18:19:00 GMT; (250156.25, « »)

How do I recreate an index file for a table after the table has been recovered?

Thanks!

All Comments

Leave a comment...

  • 2 Comments
    • There are a couple of options..

      REINDEX is the easiest, but if the key information stored in the CDX is corrupt, it will create corrupt indeces.

      The best way is to DELETE TAG <tag>, then do an INDEX ON <key> TAG <tag>. However, if you are using persistent relations, they will be removed with the DELETE TAG command.

      #1; Sun, 09 Sep 2007 20:53:00 GMT
    • Thanks Craig! I was able to do your second suggestion with success.

      #2; Sun, 09 Sep 2007 20:54:00 GMT