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. 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??). This has also happened
occasionally after a simple restructure which I usually do before adding a
batch of new records with different standard default values. It's very
frustrating as it then takes a couple of hours to put back all my colours and
fonts and move the columns to the order in which I want them. Has anybody
else encountered this? Does anyone know why it happens, and what to do to
stop it, or recover from it? Any help would be gratefully received. I've been
using Paradox since Ansa brought out Version 1.00 and this problem has been
there ever since the first Windows Version. Hope someone has an answer,
thanks!

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?


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

Thanks Anders. I don't have regular table corruption but it does happen from
time to time; the last one was this week but that was the first one for over
a year. When I went to access a particular record, Paradox closed down so I
did a verify and it reported some errors, but said that everything was ok
after a rebuild - although the formatting, as I said, had gone. I will back
up the .TV File as you suggest, if it happens again.

I don't use memo fields and I haven't been able to find out how to identity
the block size. Would this make a difference?

Anders Jonsson wrote:

vinylsol,

Why not just create a form that shows the table exactly how you want to view
it? With the form wizards, it is a pretty easy task. You can format the
fields, rearrange the columns, color the fields, etc.

To get started, when you're looking at the table view, there should be a
bunch of buttons in the upper right. Click the 'Quick Form' one, and you're
off & running. Hit F8 to get into Design mode, and start changing stuff.
Just be sure to save the form under File then Save (or Save As). From then
on, just open the form instead of the table view.

HTH,
Jim Moseley

The block size should be visible in the table repair utility.

If your table is close to the maximum number of records for it's block size
it could be an issue. With only 100 000 records I doubt it but, hopefully
someone else hera can post the details.


Anders

Anders, the block size is 16.



Anders Jonsson wrote:
--
Message posted via http://www.dbmonster.com

Thanks Jim, I don't have any problems with forms but there are occasions
where I do need to work in the table view as I need to quickly compare
records while entering data so the form view doesn't work for me all the time.
This is why I formatted the table view to make it easy to use, thus leading
to this problem. From what Anders has posted I'm suspecting that the .TV file
gets cleared during a rebuild for some reason so I'm going to try backing
that up and then restoring it if this happens again.

Jim Moseley wrote:
--
Message posted via http://www.dbmonster.com

Vinylsol,

But you can make a form that looks exactly like a table view, with as many
rows & columns as you'd like. You aren't limited to just one row on a form.

HTH,
Jim Moseley

I did a test. If a table has a .tv file, that file is moved to the repaired
table. The copy of the table loses the .tv file. So this shouldn't be your
problem.

The most common cause to lost .tv files is that the table has been copied
from Windows Explorer or a filesystem copy in ObjectPAL, and .tv file is not
included in the copy.




--
Bertil Isberg - CTECH
Paradox buglist:
online: http://hem.bredband.net/bertilisberg/

"vinylsol" <u37647@uwe> skrev i meddelandet news:78a17e86ee15a (AT) uwe (DOT) ..

Thanks Bertil. The last time this happened it was immediately after a repair
and I hadn't done any copying using WE so I can be reasonably sure that it
was related to the repair in some way.

Bertil Isberg wrote:
--
Message posted via DBMonster.com
http://www.dbmonster.com/Uwe/Forums....radox/200709/1