title: SQLite record not correct on iPhone simulator
body: <p>I have an SQLite db with 19 records in it.  Of those records 18 have a &quot;threatLevel&quot; value of 1, and one of them has a &quot;threatLevel&quot; of 2.  The field is set to default to 1.  I recently changed the 19th record to &quot;threatLevel&quot; 2 for testing purposes.
  I used <a href="https://addons.mozilla.org/en-US/firefox/addon/5817" rel="nofollow noreferrer">SQLite Manager</a> (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 &quot;threatLevel&quot; of 2.
  When I run my app in the simulator, the 19th record has a &quot;threatLevel&quot; 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:</p>
  <pre><code>primaryKey = pk;
      database = db;
      
      // Compile the query for retrieving City data.
      if (init_statement == nil){
          const char *sql = &quot;SELECT * FROM myTable WHERE id=?&quot;;
          if (sqlite3_prepare_v2(database, sql, -1, &amp;init_statement, NULL) != SQLITE_OK){
              NSAssert1(0, @&quot;Error: failed to prepare statement with message '%s'.&quot;, 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 = @&quot;Nothing&quot;;
      }
  </code></pre>
  <p><strong>EDIT</strong>
  I just tried deleting the sqlite database from the project, and I moved it to my desktop to back it up.  I can still build and run my app.
  So it's looking at an older version of my database, but Spotlight says there are no other versions on my machine except for the one on my desktop.
  Any help here?</p>