Results 1 to 4 of 4
  1. #1
    Join Date
    Jun 2013
    Posts
    1

    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.

  2. #2
    Join Date
    Dec 2007
    Posts
    366
    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

    http://www.OasisTradingPost.com

    Oasis Trading Post
    - Collectibles and Memorabilia
    - Vintage Lego Sets and Supplies
    - and Paradox Support, too

  3. #3
    Join Date
    Oct 2013
    Posts
    2
    I haven't encountered that problem so far.. but this trick might come in handy. Thanks for sharing!

  4. #4
    Join Date
    Oct 2013
    Posts
    2
    I haven't encountered that problem so far.. but this trick might come in handy. Thanks for sharing

    nettikasinot

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •