how to vacuum?

[Wolfman]

hi,

i want to vacuum my sqlite database. i know there is a statement VACUUM for it. but if i exec this statement i get an error, because i use transaction connection. how can i solve this problem to vacuum my database? do i have to close the conn, set no transaction, reopen, vacuum, close conn, set transaction and reopen again?

best regards
wolfman

[aducom]

Appearantly. Other solution is to use the auto-vacuum pragma which is rather new. It's not possible to execute vacuum when a tranaction is open.