Sqlite3 and Xcode

Question

I have a weird problem with my iphone application. I have created an sqlite3 database file with console, and added it to project usint "add existing file..." in resource folder, but when i execute project to test with simulator, application couldn't find the sqlite file. I checked Documents folder (/Users/XXXXXX/Library/Application Support/iPhone Simulator/4.2/Applications/XXXXXX/Documents/) and it's empty :^S Please, this problem is getting me crazy, i'm tired of searching a solution through web, could someone help me? Thanks in advance...

Seva Alekseyev · Accepted Answer · 2011-02-06 15:57:16Z

2

It does not go to the documents - it goes to your bundle as resources. To find out the path, use the following:

NSString *Path = [[NSBundle mainBundle] pathForResource: @"myfilename" ofType:@"db"];

edited Feb 6, 2011 at 15:57

answered Feb 6, 2011 at 15:48

Seva Alekseyev

61.9k25 gold badges174 silver badges297 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Rakius Over a year ago

Thanks so much @viggio24 and @Seva Alekseyev!!! both are right! Finally i used NSString *databasePath = [[[NSBundle mainBundle] bundlePath] stringByAppendingPathComponent: sqliteFileName]; :D:D:D:D

viggio24 · Accepted Answer · 2011-02-06 15:47:38Z

1

If you added it to XCode then the file is in the bundle, so you must check this path:

[[NSBundle mainBundle] bundlePath]

instead of the Documents folder.

answered Feb 6, 2011 at 15:47

viggio24

12.4k5 gold badges43 silver badges34 bronze badges

Collectives™ on Stack Overflow

Sqlite3 and Xcode

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related