Can't run app with SQLite - Objective-c

Question

I'm trying to catch data from a sqlite3 database and list them in an UITableView. I have added the libsqlite3 framework but when I run it I get like 10 errors, one for each sqlite line. One of the messages I get is:

"_sqlite3_close", referenced from:
 -[AppDelegate initializeDatabase] in AppDelegate.o

Almost every message are like this but with different sql lines. initializeDatabase is a method where the database is opened.

What could be wrong?

Jasper Blues · Accepted Answer · 2013-11-01 08:56:38Z

1

It looks as though you've got the libsqlite headers in your header search path, but the sqlite library itself is not linked to your target.

Click on the target for your application.
Open the Build Phases tab
Choose 'Link Binary with Libraries', and add sqlite

enter image description here

Rather, then using the raw-C interface to sqlite, which is quite verbose you may wish to use an Objective-C wrapper. One popular wrapper is called FMDB, and this library can be quickly installed using the popular CocoaPods library manager tool.

CocoaPods will save you time, by automatically linking in your libraries, as well as any transitive dependencies (libraries that the library uses). While this is very convenient its still important to gradually learn what happens behind the scenes, so do try to set up some libraries manually, as you've done, as well.

edited Nov 1, 2013 at 8:56

answered Nov 1, 2013 at 8:49

Jasper Blues

28.9k22 gold badges110 silver badges191 bronze badges

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

Collectives™ on Stack Overflow

Can't run app with SQLite - Objective-c

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related