Please help me fix "index is out of date" errors

[dwightarmy...@hotmail.com]

My software application uses Paradox tables written in Embarcadero RAD Studio/C++Builder XE. Recently, my users have been receiving "index is out of date" errors when accessing the point in the code where the tables are being set to Active. After some googling, I discovered that the tables are composed of three files, the .db file (the data portion), the .mb file (the binary "blob" portion) and the .px file (the index portion), and the problem is with the .px file. By deleting the corrupted .px file, everything works and the software application runs OK. But now I have no indexes on my table. How do I rebuild these indexes, and how do I prevent them from becoming corrupted in the future? I use Embarcadero RAD Studio XE in Windows 7 64-bit.

[szal...@gmail.com]

2013. június 7., péntek 2:14:31 UTC+2 időpontban dwightarmy...@hotmail.com a következőt írta:
> My software application uses Paradox tables written in Embarcadero RAD Studio/C++Builder XE. Recently, my users have been receiving "index is out of date" errors when accessing the point in the code where the tables are being set to Active. After some googling, I discovered that the tables are composed of three files, the .db file (the data portion), the .mb file (the binary "blob" portion) and the .px file (the index portion), and the problem is with the .px file. By deleting the corrupted .px file, everything works and the software application runs OK. But now I have no indexes on my table. How do I rebuild these indexes, and how do I prevent them from becoming corrupted in the future? I use Embarcadero RAD Studio XE in Windows 7 64-bit.

Hi!
There are a lots of other files belong to the main table (secondary index files). They can become corrupted anytime...
But, you can repair them with the Borland's (TUtility.DLL) library, I think it's free of charge. Try to download that and call its functions to repair your tables from your program.

SzLD