Login | Register   
RSS Feed
Download our iPhone app
Browse DevX
Sign up for e-mail newsletters from DevX

By submitting your information, you agree that devx.com may send you DevX offers via email, phone and text message, as well as email offers about other products and services that DevX believes may be of interest to you. DevX will process your information in accordance with the Quinstreet Privacy Policy.

Tip of the Day
Language: Relational Databases
Expertise: Beginner
May 13, 1997



Application Security Testing: An Integral Part of DevOps

"Index is out of date" message appears when searching Paradox database

When I search in a Paradox database when I use Delphi, I get the message "Index is out of date." Why?

This error message is usually attributed to making a copy of the table to a new directory and overwriting the old copy. But there's a twist: Not only do you have to copy the table itself, you must copy all the files with the same name as your table to the new directory. This includes all files with the extensions: PX, XGn, YGn (where n = 0, 1, 2 depending on the secondary index), and TV (I think there might be a couple more).

For example, if I have a table that has a primary index, and a couple of maintained secondary indices associated with it, I'd have a set of files that looks like this:

To properly use the table in different directories, I'd have to copy all the files above to the new directory, overwriting any existing files. If I don't do this, I'll get an "Index out of date" error when I try to access the table.

The only other reason you'll get this error is if one of your indices was corrupted in some way. To correct the problem, open the table in restructure mode in the Database Desktop, redefine your indexes, then re-save the table.

DevX Pro
Comment and Contribute






(Maximum characters: 1200). You have 1200 characters left.



We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.
Thanks for your registration, follow us on our social networks to keep up-to-date