Good Morning!
Have a very wide dbf with about 8 memo fields . Started
acteing strange like if I tried to re-index or pack memo it would seem to
go so far and then freeze!
Found a utility that seemed to repair the file. The only issue is that the
DBF is 710mb and the associated memo file is 1.2
When you select * to a temp table. What is the size of the files?
You'll know quickly if you have bloat.
HTH,
Tracy
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Desmond
Lloyd
Sent: Monday, October 05, 2020 9:49 AM
To: profoxt...@leafe.com
Subject:
Fascinating, original size of the DBF 710448
original size of fpt: 1276848
selecting * from the tabl3
DBF = 710448
FPT = 923354
A drop in the size of the fpt of 353492.. Could i rename the "selected" FPT
and use it. I treid a pack memo and there no change in thesiz of the FPT?
Regards,
Desmo
If it is a Free table, you could. If it is in a DBC, you may have troubles.
If I remember correctly, there is a header connecting a table to a DBC.
You may need to ZAP the original and append from the Free table. However, if
you have an AutoInc integer field, you'll have problems.
HTH,
Tracy
-
I "think" the way to do this is to copy the data to a new table and then
delete the old table and rename the new one to the old name, but it's
been a really long time since I worked with DBFs so caveat emptor!
Be careful if the table is part of a database and you have specific
configuration se
Do not use an FPT from one table with another.
I am a little surprised that the PACK MEMO did not recover space. Are
you sure you refreshed the disk folder where the .fpt was stored.
Also, since you had to have the table open exclusively to do a PACK
MEMO, why not just do a complete PACK. If
On 10/5/2020 2:30 PM, Charlie wrote:
Or, create additional tables, 1 memo field each (assuming your 8 memo
fields hold roughly equivalent amounts of data). Then link them back
to the main table - aka main tables primary key. Of course, this would
impact your data queries when pulling data. An
7 matches
Mail list logo
