SQLite vacuum statement

[JanRoza]

On the SQLite website I read that you can use the vacuum statement on a SQLite database.
Can anyone give me an example of how to do this?
In my application I have only TSQLite3Datatsets, so how to perform an Vacuum statement on a whole database?
I know there is the auto-vacuum option but I did not knew that when the database was created and it can only be set at creation time, so that's why I want to use the vacuum statement. Unfortunately i have been unable to find an example.

Any help is welcome.

Jan

[LuizAmérico]

Dataset.ExecSQL('VACUUM');

[JanRoza]

Thanks Luiz.
As a dataset is connected to just one table in the SQLite database, does this mean you can perform this on any dataset and the result will be the whole SQLite database that has been vacuumed?

[JanRoza]

Problem solved!
dataset.execsql('VACUUM') indeed compacts not just that dataset but the whole database.
It's easy, once you know it.

 
Jan