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 set for the table in the dbc (long column names, autoinc, triggers).
If that is going to be a problem maybe copy it to a new table, then zap the old table and append from the new table but you'd still have to look out for autoinc.
Frank.
Frank Cazabon
On 05/10/2020 10:37 am, Desmond Lloyd wrote:
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, Desmond
/
On Mon, 5 Oct 2020 at 09:06, Tracy Pearson tracy@powerchurch.com wrote:
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-bounces@leafe.com] On Behalf Of Desmond Lloyd Sent: Monday, October 05, 2020 9:49 AM To: profoxtech@leafe.com Subject: My memo field(s) Are Bloated......
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.2gb! Yikes. Have ran a pack memo (with no issues) and there is no change in the size of the memo file, which I am assuming is boated.
1.) Is the memo file really bloated. 2.) Going to look at the individual memo fields and see if any one of the records has an unusually large memo field. 3.) Open to any other suggestion that you wise people could recommend....
TIA/Regards, Desmond
--- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html
[excessive quoting removed by server]