I created an sqlite3 database using navicat and then added to my XCode project. When my applications runs all the queries execute fine. But there is no database in the documents folder of the simulator. Where is the database being saved?
2 Answers
Assuming you haven't copied the database into your Documents directory, then it'll be in your app's main bundle, which is at <AppName>.app at the root of your application.
You can't write to that file.
If you want to make changes to this file you'll have to copy it from there to your Documents directory.
2 Comments
Sherman Lo
You copy it in code the first time the app runs. You'd then open the sqlite file in the documents directory instead of the one in the bundle. stackoverflow.com/questions/6545180/… has some sample code for copying a file from the bundle to your documents directory.
VBK
Thanks a lot for your help it works. This should work on the phone itself also right ?
Inserting a data into SQLite (using FMDB) doesn't work on device?
Check my Answer on this Question. It is pretty much the same.
