> > Does Restructuring help? Perhaps after deleting the index (.PX?)
> By this, do you mean to Pack the table (in DBD) after deleting the
index?
> Is there any difference between using the DBD / Erase index and merely
> deleting the .PX file? I will try this.
something else to try
delete all the relevant index files
build a new empty set of tables including all the indexes
as they should be.
then copy the data from the old orphaned DB file
into the new empty tables.
you may want to do this via a query that orders
them on the autoincr field so that the original
ordering will be preserved. NOTE!!! if there
are gaps in your numbering this will renumber them.
Only you know if this matters to your app. If
there are references in other tables to the
autoincr key you will get into trouble.
then (with luck) you won't have the problem with
the new table
> Have just figured that there is only one place in my app that needs
the
> table ordered this way and think I might change things to use a TQuery
with
> an Order by clause. It's not speed critical.
just ignoring the problem won't make it go away.
there's something wrong with your table - if you
don't fix it now - it will fix you later.
good luck.
Paradox is one of the best reasons to use to Interbase.
-ns
---------------------------------------------------------------------------
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"
Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/
