From: moroivan@compuserve.de   
      
    schrieb im Newsbeitrag   
   news:20061023155949.767$QY@newsreader.com...   
   > My supervisor uses Paradox 10 for all his reporting for well over a   
   decade.   
   > Just recently, he has encountered a "table full" error. He is working   
   with   
   > a very large set of data; over 416,000 records with 300 columns per   
   record.   
   > His systems is running XP Professional with a P4 running at 3 GHZ with 2   
   > Gigs of memory. While searching the web I found a reference to a fix   
   that   
   > involving changing the block size.   
   >   
   > Can anyone suggest a fix or point me in the right direction t fix his   
   > problem.   
      
   there's a way do restructure the table directly, but with a buggy method   
   restructure(). therefore i recommend the mentioned way to create a new table   
   and add the old records to the new.   
      
   here's the way with restructure - but make a backup and prove first, if it   
   really works without problems:   
      
   var   
    dy DynArray[] AnyType   
    tb Table   
   endVar   
      
   dy["blockSize"] = 4096 ; or higher e.g. 16384, ...   
   tb.attach("TableToRestructure")   
   tb.restructure(dy)   
   tb.unAttach()   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)   
|