.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