Quote:
Originally Posted by Ken Maltby
Right the free version has three major tabs "Database Structure" "Browse Data" and "Execute SQL". I ran "vacuum" as a query and it reported "No Error", but I don't think it did much. There was nothing in the "Data returned:" area.
|
That is the expected result. If it works, it produces that. If it doesn't, there will be an error. The only time I have seen an error was when the database was corrupt.
Quote:
So in the windows version of SQLite the "File" tab selection "Compact Database" means what? Is it not what you guys are talking about or do you only get that in the "Expert" version?
|
"Compact database" will run "vacuum". It is a short curt to running the vacuum statement. It might wrap it in checks and probably displays a message box at the end, but the only thing important is that it runs vacuum.