Paradox Community

Items in pnews.paradox-development

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


Copyright © 2004 thedbcommunity.com