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 8,813 of 9,834   
   Anders Jonsson to All   
   Re: Table formatting disappears   
   23 Sep 07 08:43:08   
   
   From: gt3TakeThisAway@bredband.net   
      
   > I'm using Paradox 10 as a flat file database with just over 100,000   
   > records   
   > with 52 fields. My forms work ok but I do a lot of work in the table view   
   > and   
   > every now and then, over the years, I've had to rebuild a table after a   
   > record has been corrupted.   
      
   100 000 records shouldn't be a problem per se but 52 fields is a rather wide   
   table, but should also be OK. Regular table corruption is not normal in   
   Paradox and usually caused by bad hardware, bad users or bad programming.   
   Neither of this should an issue in your case as I understand it so there   
   must be something else. What block size is the table. Do you have a lot of   
   memo fields?   
      
      
   > When I do this all the formatting for the table   
   > view disappears, leaving me with a plain white table. If I then recover a   
   > previous version of the table, the formatting is gone from that as well   
   > (leading me to conclude that that the formatting is stored somewhere in   
   > Paradox rather than in the .DB file itself??).   
      
   The formatting is stored in a file with the same name as the table but with   
   .TV extensions. You could try to backup that file prior to your table   
   rebuild and restore it afterwards. I haven't done this myself but it might   
   work.   
      
   Anders   
      
   --- 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