Recent

Author Topic: TDbf EmptyTable: Memo .dbt file not emptied  (Read 129 times)

Lansdowne

  • New Member
  • *
  • Posts: 22
TDbf EmptyTable: Memo .dbt file not emptied
« on: November 12, 2022, 11:41:05 am »
I have a set of dBase format tables, and one includes a field of type Memo (aka Blob) to contain strings of unspecified length.

I have a procedure to rebuild the tables from a CSV backup.  The First part of this procedure is to call Tdbf.EmptyTable for each table.

After emptying the tables, all the file sizes on disk are small as expected, except the .dbt file that holds the blob data which is currently 7MB in size so it still contains the blob data for the deleted records.

Looking at the TDbf source code briefly, the Zap procedure does not seem to attempt to deal with an external memo file of this type.

Is this simply something that is not implemented in TDbf ?

Thaddy

  • Hero Member
  • *****
  • Posts: 12643
Re: TDbf EmptyTable: Memo .dbt file not emptied
« Reply #1 on: November 12, 2022, 12:16:30 pm »
It seems not implemented, but it also seems easy to fix: if a memo file is present that also needs to be zapped.
"Looks" OK, doesn't mean it is IS OK.

 

TinyPortal © 2005-2018