SQLite record not correct on iPhone simulator
I have an SQLite db with 19 records in it.  Of those records 18 have a "threatLevel" value of 1, and one of them has a "threatLevel" of 2.  The field is set to default to 1.  I recently changed the 19th record to "threatLevel" 2 for testing purposes.
I used [SQLite Manager][1] (a Firefox extension) to add the value directly to the sqlite file in my project.  I can query the table and it shows that the 19th record has a "threatLevel" of 2.
When I run my app in the simulator, the 19th record has a "threatLevel" of 1.  I have tried cleaning my build, uninstalling the app from the simulator, even removing the sqlite database from my project and readding it.  Nothing works.  SQLite Manager says it has a value of 2, but when the program is run it gets a value of 1.
The code to load it into the class from the DB is this:

    primaryKey = pk;
		database = db;
		
		// Compile the query for retrieving City data.
		if (init_statement == nil){
			const char *sql = "SELECT * FROM myTable WHERE id=?";
			if (sqlite3_prepare_v2(database, sql, -1, &init_statement, NULL) != SQLITE_OK){
				NSAssert1(0, @"Error: failed to prepare statement with message '%s'.", sqlite3_errmsg(database));
			}
		}
		
		sqlite3_bind_int(init_statement, 1, primaryKey);
		if (sqlite3_step(init_statement) == SQLITE_ROW){
                    LOAD THE FIRST 12 FIELDS HERE
		    self.threat_level = sqlite3_column_int(init_statement, 13);
		} else {
			self.name = @"Nothing";
		}


  [1]: https://addons.mozilla.org/en-US/firefox/addon/5817
SQLite record not correct on iPhone simulator
===

I have an SQLite db with 19 records in it.  Of those records 18 have a "threatLevel" value of 1, and one of them has a "threatLevel" of 2.  The field is set to default to 1.  I recently changed the 19th record to "threatLevel" 2 for testing purposes.
I used [SQLite Manager][1] (a Firefox extension) to add the value directly to the sqlite file in my project.  I can query the table and it shows that the 19th record has a "threatLevel" of 2.
When I run my app in the simulator, the 19th record has a "threatLevel" of 1.  I have tried cleaning my build, uninstalling the app from the simulator, even removing the sqlite database from my project and readding it.  Nothing works.  SQLite Manager says it has a value of 2, but when the program is run it gets a value of 1.
The code to load it into the class from the DB is this:

    primaryKey = pk;
		database = db;
		
		// Compile the query for retrieving City data.
		if (init_statement == nil){
			const char *sql = "SELECT * FROM myTable WHERE id=?";
			if (sqlite3_prepare_v2(database, sql, -1, &init_statement, NULL) != SQLITE_OK){
				NSAssert1(0, @"Error: failed to prepare statement with message '%s'.", sqlite3_errmsg(database));
			}
		}
		
		sqlite3_bind_int(init_statement, 1, primaryKey);
		if (sqlite3_step(init_statement) == SQLITE_ROW){
                    LOAD THE FIRST 12 FIELDS HERE
		    self.threat_level = sqlite3_column_int(init_statement, 13);
		} else {
			self.name = @"Nothing";
		}


  [1]: https://addons.mozilla.org/en-US/firefox/addon/5817