Mombu the Programming Forum

Go Back   Mombu the Programming Forum > Programming > Paradox index corruption
User Name
Password
REGISTER NOW! Mark Forums Read




Reply
1 5th October 13:17
richardb
External User
 
Posts: 1
Default Paradox index corruption



I remember there was a problem with Paradox indexes many years ago(1998-99?). We had to use Database Desktop, delete and recreate the indexes. The indexes seemed to become corrupted after a certain time. I need to help somebody with this same bug today (I personnaly moved to C# 18 months ago). His app was developped with Delphi4 but i got no idea of the Paradox version, surely an old one ! Was that paradox bug finally fixed ? What is the most recent version of Paradox ? I didn't find a lot of posts about Paradox... Everybody has moved to Interbase it seems...

I guess the Paradox team has fixed this thing since then. I'd like to give my friend a final solution. Any link ? Idea ?

Thanks in advance.
  Reply With Quote


 


2 16th October 19:29
dai wei
External User
 
Posts: 1
Default Paradox index corruption



If you need a Java solution. Your friend can visit www.hxtt.net to
download HXTT Paradox, a type 4 JDBC driver for Paradox version from
3.0, 3.5, 4.x, 5.x, 7.x to 11.x. Then run once "REINDEX ALL on
yourtableName" to fix corrupted index files. That's all since HXTT
Paradox is free for evaluation purpose without function limitation.
  Reply With Quote
3 12th November 03:11
max-ph. blickenstorfer
External User
 
Posts: 1
Default Paradox index corruption


Beside the remark of Paul regarding the wrong group.
Pdox had problems with large tables if the data was not properly flushed to
disk. A possible workaround is to periodically close and reopen the table.

I still do have some old applications running against a pdox db, some really
far too large. However, there is an example of a reindex along with the bde
api. You could download the smaple "DTUTIL32", your client/customer could
rebuild tables easily. I did a small prog. to reindex a list of tables in a
row. As I said, some tables became huge and it took hours to complete a full
rebuild of 100+ tables. If you are interrested in the delphi code post me by
mail.

Regards
Max

ago(1998-99?). We had to use Database Desktop, delete and recreate the
indexes. The indexes seemed to become corrupted after a certain time. I need
to help somebody with this same bug today (I personnaly moved to C# 18
months ago). His app was developped with Delphi4 but i got no idea of the
Paradox version, surely an old one ! Was that paradox bug finally fixed ?
What is the most recent version of Paradox ? I didn't find a lot of posts
about Paradox... Everybody has moved to Interbase it seems...


my friend a final solution. Any link ? Idea ?
  Reply With Quote
Reply


Thread Tools
Display Modes




666