Unanswered: Correct way to fix "index is out of date" errors
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.
don't know what re-indexing capabilities that app has, if any, but that's all you need to do.. real paradox can simply re-index the table and/or re-synch secondary indexes.. direct calls to the BDE, the internal engine, can do the same.. I have no idea what functions are built into the system, since it was purchased by Embarcadero, but most likely it involves BDE calls
Steven Green - Myrtle Beach, South Carolina USA