Devart Forums

Hello.

When i run the statement
ConBDSqlite.ExecSQL('VACUUM',[])
with an active transaction, it return the error
cannot VACUUM from within a transaction.

If before that i run the statement
ConBdSqlite.Commit
it return the error
cannot VACUUM - SQL statements in progress.

What I'm doing wrong.

Thank in advance.

Hello.

The problem is due to specificity of SQLite.
To perform the VACUUM command in SQLite you have to finish all active transactions.
Also, the VACUUM command can not be executed when there are opened datasets with the property FetchAll set to False.
You can find more information about the VACUUM command in the official SQLite documentation here: http://www.sqlite.org/lang_vacuum.html