I am new on iphone programming.. I keep getting the error and I have no idea how to change the permission for SQLite
Error while updating. attempt to write a readonly database
and the following is my coding
NSString *filePath = [[NSBundle mainBundle]pathForResource:@"card" ofType:@"sqlite"];
sqlite3_stmt *statement;if(sqlite3_open([filePath UTF8String], &db) == SQLITE_OK)
{
const char *query_stmt = "UPDATE card SET isActivate =?";
if(sqlite3_prepare_v2(db, query_stmt, -1, &statement, NULL) != SQLITE_OK)
{
NSAssert1(0, @"Error while creating update statement. '%s'", sqlite3_errmsg(db));
}
}
sqlite3_bind_int(statement, 1, 1);
if(SQLITE_DONE != sqlite3_step(statement))
{
NSLog(@"Error while updating. %s", sqlite3_errmsg(db));
}sqlite3_finalize(statement);
sqlite3_close(db);
Hope someone could help me because this really makes me feel frustrated..