home bbs files messages ]

Forums before death by AOL, social media and spammers... "We can't have nice things"

   comp.databases.paradox      To crash or not to crash, asks Borland      9,834 messages   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]

   Message 7,899 of 9,834   
   moroivan to dmacias666@LABridge.com   
   Re: Table Full error   
   02 Nov 06 10:29:17   
   
   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)   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]


(c) 1994,  bbs@darkrealms.ca