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