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

Hot Topic

which is safer to use table or view?
import from excel
Preview container toolbar doesn't respond
MyEditor (Edit Control) Validation in VFP-9: STOPPING Menus, etc?
_ReportPreview
MyEditor (Edit Control) Validation in VFP-9: STOPPING Menus, etc?
Report Issues for VFP9 after upgrade from VFP8
12 hour time format
Foxpro in Visual Studio 2005
Line Printer Font (16.66cpi)

Visual FoxPro

Help with a form
Cursor help
COM application using to much memory
Undoing the changes done in a form and exit
Inserting and Updating images file from VFP9 to SQL Server 2005
Grid objects problems/questions
cumulative column calculation
sometimes no response to mouse clicks.
MSGraph.Chart.8 control
How to get IP Address on Clien of LAN....? Help me!!!!!!

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

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

Thanks!

Answer this question

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

  • Qdawg

    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.

  • Sathiya Sivam

    Thanks Craig!  I was able to do your second suggestion with success.  Big Smile
  • Index does not match the table. Delete the index file and re-create the index (Error 114)
Answer this question