OK
Thanks to all who replied.
I think that there are only about 24,000 records in the table. Not sure if
the network is slow - but the client workstation certainly is, and is about
to be upgraded.
Bevan, you suggest changing the block size "For those few problem tables" to
32k. How do you go about changing that setting at the table level?
Is there a neat way of copying records from the old table into the new one?
Given that the secondary index is no longer there, I guess that merely
rebuilding is never going to bring it back - so I HAVE to find a way of
re-creating it.
Both sites (mine and the client) are using the same version of the BDE
(5.01).
When I look at my Paradox files they are version7 and I am assuming that the
client site is the same (or does the upgrade not happen automatically with a
BDE upgrade?).
I have a utility here called DTutil32.exe. Not sure where it came from - is
this adequate for doing these sorts of rebuilds? There are others around
that require an empty copy of the database to be maintained for reference in
rebuilding databases.
Are these latter types able to recover from more corrupt databases than the
above utility?
Do these utilities fix more problems than it is possible to fix by merely
deleting and re-creating the indexes?
In the meantime I have produced a work around the immediate problem for the
client - but will have to provide a more permanent fix next week.
Thanks again
Mark
----- Original Message -----
From: "Bevan Edwards" <[EMAIL PROTECTED]>
To: "Multiple recipients of list delphi" <[EMAIL PROTECTED]>
Sent: Thursday, November 16, 2000 3:02 PM
Subject: Re: [DUG]: Can't make secondary index on Paradox table
>
> Hi Mark,
>
> One more thing just sprang to mind. I had endless problems with indices
> on Paradox tables and eventually tracked it down to having a large
> number of records (100,000+) and the block size set to 2k (by default).
>
> For those few large tables, I specifically changed the BDE Paradox
> Driver settings to 32k block size, re-created the table (Borrowing the
> structure and index definitions from the original table) and then added
> all of the records from the original table to the new table. Since then
> I haven't had any problems with corrupted indices.
>
> I also noticed that this only happened over a slow network, and I never
> seemed to get the problem if the files were on a local drive.
>
> Regards,
>
> Bevan
>
> --
> Bevan Edwards mailto:[EMAIL PROTECTED]
> Achieve Software Limited http://www.achieve.co.nz
> Phone: (64-9) 444-4210 ICQ: 732011
> Fax: (64-9) 444-4201
> Mobile: (64-21) 979-603
> --------------------------------------------------------------------------
-
> New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
> Website: http://www.delphi.org.nz
> To UnSub, send email to: [EMAIL PROTECTED]
> with body of "unsubscribe delphi"
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
To UnSub, send email to: [EMAIL PROTECTED]
with body of "unsubscribe delphi"
