My Oobase file is growing, elseif I DELETE table's content.

[Gianluca]

Hi all

I created an OoBase file with a main table that periodically should be emptied and its contents renewed.
This table is in fact populated by a spreadsheet file contents.
In order to empty the table I'm using the "DELETE FROM" SQL command, that, from a logical point of view seems to work fine.

BUT

the OoBase file is growing time by time, despite the fact that its main table is (sometime ) empty.

My understanding is that DELETE does a logical deletion without phisical removing od the data.
I would like to phisically delete data, in order to have a lighter file,at the end.
Anyone could help me?

many thanks
Gianluca
_________________
Forget computers, visit Italy.

[Sliderule]

Gianluca:

Please see the link below, for instructions on how do remove the data from your Base ( HSQL ) database file, and, result in a smaller size ODB file.

http://www.oooforum.org/forum/viewtopic.phtml?t=52208

I hope this helps, please be sure to let me / us know.

Sliderule

[Gianluca]

Woh, sliderule

I really did not expect a so quick answer.

I tried the 'CHECKPOINT DEFRAG' and worked perfectly.

thanks a lot
Gianluca
_________________
Forget computers, visit Italy.