Subject: | Re: table repair quirk
| Date: | Sun, 25 Nov 2018 21:37:20 +0000
| From: | Michael Kennedy <Info@KennedySoftware.ie>
| Newsgroups: | pnews.paradox-development
|
A few thoughts...
To me, 80,000 does not seem large, but 24 does ;-)
How about copying the table structure only, and then "adding" all the
current data into the new structure, etc...
Or... How about splitting the current table into, say, three sub-tables,
with about 27,000 records each (well under that darn 32,768 limit!), and
then running Repair on each sub-table. If each sub-table is error-free,
that might suggest that the data in the individual records is not the
problem, but perhaps the "volume" of records, and you might have hit a
variation of that darn 32,768 issue among all those secondary indices.
Also, if you have ChimneySweep handy, maybe it's worth a shot? (However,
I did try/stress it (a lot!), some years ago, with no success!).
- Mike
On 25/11/2018 14:29, Steven Green wrote:
> huge table.. 80,000 records, 24 sec indexes, a couple of memo fields..
> no, I didn't create this monster
>
> repair says record 28728 is out of sort order.. rebuild, still there..
> delete it, now the record BEFORE it is now out of sort order, not the
> record AFTER it
>
> stranger still, there's seemingly nothing wrong with the record that
> stops anything.. I can add it back to the table w/o an error, I can edit
> it and leave the record w/o an error, so none of the lookup values is
> invalid
>
>
> --
>
> Steven Green
> Myrtle Beach, South Carolina, USA
>
> http://www.OasisTradingPost.com
>
> Collectibles and Memorabilia
> Vintage Lego Sets and Parts
> - and Paradox support, too
|