Restructuring Paradox tables

[StevenK]

I'm looking for some Delphi 5 code to allow my users to restruture Paradox tables (following table corruption and the like). I'd be grateful if anyone could tell me the best way to handle this. Ideally I'm looking at restructuring the table maintaining the data in the table, reconstructing the primary key and all secondary indexes.
This saves us time when we need to dial into client sites to restructure tables following network issues.
Any help would be appreciated.
Steve

 

[TealWren]

Hi Steve,

Borland provides TUtility which is a utility that will reindex, pack, etc. (if I remember correctly) paradox files. It has source so you can change the interface or integrate it into your own program. It's an "unsupported" utility but it works quite well in most instances.

http://www.borland.com/devsupport/bde/utilities.html

TealWren

 

[StevenK]

Will this/these utilities maintain the secondary indexes ?
What happens if my tables are already corrupted (messages like 'Corrupt index' or 'Index is out of date' ?
Will the utility/procedures correct this ?
Thanks again.
Steve

 

[TealWren]

They won't fix everything, but then again neither will Paradox. They will rebuild all indexes, secondary & primary.

If I remember right TUtility is the DLL you need and there are programs already written that use it, you can get and modify those or use the API to write your own.

TealWren