SQL3 differences between simulator and iPod Touch

[dbrownstone]

I am using an sql database. Works fine with the simulator but when I test on iPod Touch, the statement "if(sqlite3_prepare_v2(database, sql, -1, &compiledStatement, NULL) == SQLITE_OK)" is never true i.e. does not fine anything in the database.

Anyone have any suggestions where to look?

Thanks

[lbendlin]

folder names are different on the device. show us how you access "database"

[dbrownstone]

Originally Posted by lbendlin

folder names are different on the device. show us how you access "database"

static sqlite3 *database = nil;
static NSString *kDatabaseName = @"mydatabase.db";
NSArray *documentPaths = NSSearchPathForDirectoriesInDomains(NSDocumentDire ctory, NSUserDomainMask, YES);
NSString *documentsDir = [documentPaths objectAtIndex:0];
NSString *databasePath = [documentsDir stringByAppendingPathComponent:kDatabaseName];

if (sqlite3_open([databasePath UTF8String], &database) != SQLITE_OK) {
.....

[dbrownstone]

static sqlite3 *database = nil;
static NSString *kDatabaseName = @"mydatabase.db";
NSArray *documentPaths = NSSearchPathForDirectoriesInDomains(NSDocumentDire ctory, NSUserDomainMask, YES);
NSString *documentsDir = [documentPaths objectAtIndex:0];
NSString *databasePath = [documentsDir stringByAppendingPathComponent:kDatabaseName];

if (sqlite3_open([databasePath UTF8String], &database) != SQLITE_OK) {
.....

[lbendlin]

The database file is initially in the bundle folder. You need to copy it to the documents folder if it doesn't exist there. Look at the SQLBooks example for 'copydatabaseifneeded'

[dbrownstone]

Originally Posted by lbendlin

The database file is initially in the bundle folder. You need to copy it to the documents folder if it doesn't exist there. Look at the SQLBooks example for 'copydatabaseifneeded'

I guess I missed that! However, surely if the db is not in the right place, the sqlite3_open would fail - it did not!

[bgeerdes]

Originally Posted by dbrownstone

I guess I missed that! However, surely if the db is not in the right place, the sqlite3_open would fail - it did not!

Yeah, sqlite3_open never fails.

[lbendlin]

oh, it can fail easily, and if you don't implement your own checks it will happily open nonexisting databases and write to them. Been there, done that.

[dbrownstone]

Originally Posted by lbendlin

oh, it can fail easily, and if you don't implement your own checks it will happily open nonexisting databases and write to them. Been there, done that.

Well whatever... I did make the change - adding something along the lines of the "copydatabaseifneeded" code as you suggested, and, after cleaning up the iPod, it worked!!

Thanks for the help.

[bgeerdes]

Originally Posted by lbendlin

oh, it can fail easily

Well, if you want to be technical, *it* thinks it never fails and never returns an error code (as far as I can tell).