Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


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

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

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

Answer:
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:

MyTable.DB
MyTable.PX
MyTable.XG0
MyTable.XG1
MyTable.YG0
MyTable.YG1
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.

 

 

Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date