Hi all, I develop a database app

[OO]

Hi all,

I develop a database application on Delphi 1 with paradox 5 tables.

I am using BDE 2.5 for 16-bits platform.
I face an index error when accessing a given table.

Action 1 : No way to solve this problem with the pack() method of TwwTable (INFOPOWER library is integrated to the application)

Action 2 : No way to solve this problem with the utility PxRepair 1.0 (designed by Fred Batty). If I run this utility on this table, I cannot retrieve the links with other tables

Do you have any other suggestions ?

Thanks
Regards,

Olivier OPPIZZI

 

[Robertio]

Depends on what you error is, our normal solution if we cannot access the table through database desktop is to tell the users to restore from backup.
If you can get into the table but are getting errors then you might be able to backup the table, create a new version (or copy a blank, working version of the table) and copy the data from the broken table to the new one.
If it is just an index based problem, you should be able to delete off the appropriate index file and once you can open the table recreate that index.

 

[Ronin441]

Have you tried the Paradox Rebuild Tool?

http://www.delphi32.com/vcl/4557/

And if it's a secondary index that's corrupt, you can delete the .XG? and .YG? and then regenerate the index using SQL or database desktop. Never tried this trick with a primary index, though.
-- Doug Burbidge mailto:doug@ultrazone.com

http://home.iprimus.com.au/dougburbidge/