Markus Posted October 27, 2008 Share Posted October 27, 2008 I deleted all data from a *.db file created by the usual autoit sql functions with the _SQLite_Exec(-1, "DELETE FROM...") command. the select query didn't find any data after that anymore. But if I look at the *.db file it still has the same size and if i open it in notepad the data is still there. (Maybe familiar problem but couldn't find a thread here) "It's easier to disintegrate an atom than a prejudice." (A.Einstein)---------------------------------------------------------------------------My C++ - tools:Tidy tool-->indents your c++ sourceCleanscript --> cleans autoit-code before compiling (co-author: peethebee)My tools:GUIBuilder-->build your window and get the source; german versionMy Games:OnlineGameCenter-->Online Chess and Connect4 with a rtf-chatSnake-->including a level editor to build your own levelsTetris-->the well known game, big funOther things:Tower of Hanoi-->perfect riddler with graphic output Link to comment Share on other sites More sharing options...
Vakari Posted October 28, 2008 Share Posted October 28, 2008 (edited) I deleted all data from a *.db file created by the usual autoit sql functions with the _SQLite_Exec(-1, "DELETE FROM...") command. the select query didn't find any data after that anymore. But if I look at the *.db file it still has the same size and if i open it in notepad the data is still there.(Maybe familiar problem but couldn't find a thread here)After the "Delete From", VACUUMSQlite Query Language: VACUUM Edited October 28, 2008 by Vakari Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now