> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
> Behalf Of Mark Howard
> Sent: Saturday, 18 November 2000 09:29
> To: Multiple recipients of list delphi
> Subject: Re: [DUG]: Can't make secondary index on Paradox table
>
>
> 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?).
No it doesn't. DBD will upgrade the tables at restructure to the level
needed to support the feature set requested, only if that is necessary.
There is a utility on the Borland site that will upgrade tables to a higher
level.
>
> 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?
As I understand it - the occasions on which you will be able to rebuild from
a borrowed structure from an original of the tables is quite small.
> Do these utilities fix more problems than it is possible to fix by merely
> deleting and re-creating the indexes?
Yes. If the table's header is corrupted it can usually be rebuilt. Whereas
in DBD you may not even be able to open the table.
---------------------------------------------------------------------------
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"
