Eme Fibonacci Well-Known Member Licensed User Longtime User Oct 4, 2017 #1 I've noticed that every time my project runs these files are created. If I make any changes in the database (for example a new entry) and delete .db-shm and .db-wal files the changes are lost. 1) How to eliminate dependency on these files? 2) What theses files means? Thank you.
I've noticed that every time my project runs these files are created. If I make any changes in the database (for example a new entry) and delete .db-shm and .db-wal files the changes are lost. 1) How to eliminate dependency on these files? 2) What theses files means? Thank you.
Eme Fibonacci Well-Known Member Licensed User Longtime User Oct 4, 2017 #2 When SQL1.Close is used the changes are committed and the files are deleted. Thank you. Upvote 0
Erel B4X founder Staff member Licensed User Longtime User Oct 4, 2017 #3 The files will not always be deleted. They are part of the database when the journal mode is set to wal. Upvote 0
The files will not always be deleted. They are part of the database when the journal mode is set to wal.
Eme Fibonacci Well-Known Member Licensed User Longtime User Oct 4, 2017 #4 When I was using journal mode the foreign key records were not was deleted on cascade. Now I use only PRAGMA foreign_keys = ON. The files .db-shm and .db-wal are created quando app run. They are automatic deleted when I use SQL1.Close. Upvote 0
When I was using journal mode the foreign key records were not was deleted on cascade. Now I use only PRAGMA foreign_keys = ON. The files .db-shm and .db-wal are created quando app run. They are automatic deleted when I use SQL1.Close.
