Question:
I am working on a Delphi program in which I am inserting information into a database table by running a student’s ID card through a scanner. I was testing my program and at some point in time when I had a student scan his card, I received an error message saying, “Index is out of date. Table:c:kathystudent.DB”. Student.DB is the name of my database table and I have no idea what this error means. I have looked everywhere in my Delphi books for some help on this problem, so I hope you can help me.
Answer:
Don’t fret. The “Index out of date” message can mean a couple of things:
- You copied your table into the directory, but didn’t bringits index file along to overwrite the one that’s there.
- Your index is corrupt.
In any case, do the following:
- Open up your table in Database Desktop.
- Restructure it.
- Define/Rebuild all your indexes.
- Save the file.
This is the only way to fix a bad index.