.blb file not shrinking after deleting ALL entries

Andrew Sinning andrew at learningware.com
Sun Feb 15 13:59:12 CST 2004


I asked about this last week, but didn't have time to follow up.

I add 100 entries to a table.  The table has a single BLOB field.  My
.blb file grows to 3.5Mb.

Now, I execute 2 queries:

DELETE FROM testTable
COMPACT  (I also tried "COMPACT DATABASE" at Ruslan's suggestion)


The size of the .blb file is STILL 3.5Mb.

If I test the number of records in testTable, I get 0.


What is going on?  Thanks!




More information about the Valentina mailing list