sqlite on the device

[djp_phillips]

I have a major issue with sqlite3.

On the iPhone simulator it works fine, albeit the iphone simulator caching the DB so I can't actually test if my app is responding to dynamic data in the sqlite DB.

But on the device it seems that I can't even get the database working.

I am doing a simple select query, and as I've said, the iPhone sim. is fine but the device doesn't go into the statements after:

if(sqlite3_prepare_v2(database, [sql UTF8String], -1, &compiledStatement, NULL) == SQLITE_OK)

So I'm guessing that database wasn't set up properly on the device ?

What are the differences between the device and simulator for the sqlite database ?

[dljeffery]

You are probably just not creating your database in the proper location. On the device, it needs to be somewhere in the app's documents directory, whereas on the simulator it will work just about anywhere.