title: How to close database in sqlite in ios?
body: <p>I am using SqliteDatabase in my project.I am calling a function for data manuplation.</p>
  
  <pre><code>-(void)updateInspectionMapData2:(NSString *)clientid : (NSString *)inspectionid : (NSString *)status
  {
      NSLog(@"EIGHT");
      NSLog(@"inside update data");
  
      const char *dbpath = [databasePath UTF8String];
      if (sqlite3_open(dbpath, &amp;database) == SQLITE_OK)
      {
          NSArray *checkVal = [self getSubClientDataByInspectionId:inspectionid :clientid];
          NSLog(@"check is %@",checkVal);
          if(checkVal == nil || [checkVal count] == 0)
          {
              NSString *querySql=[NSString stringWithFormat:
                                  @"UPDATE inspectioninspectormap SET status=\"%@\" where inspectionid = \"%@\" and clientid =\"%@\" and (status = \"1\" or status = \"2\")",status,inspectionid,clientid];
              NSLog(@"sql is %@",querySql);
              const char *sql=[querySql UTF8String];
              if(sqlite3_prepare_v2(database,sql, -1, &amp;statement, NULL) == SQLITE_OK)
              {
                  if(SQLITE_DONE != sqlite3_step(statement))
                  {
                      NSLog(@"Error while updating. '%s'", sqlite3_errmsg(database));
                  }
                  else
                  {
                      sqlite3_reset(statement);
                      NSLog(@"Update done successfully!");
                  }
              }
              sqlite3_finalize(statement);
          }
  
      }
      sqlite3_close(database);
  
  }
  </code></pre>
  
  <p>Please tell me is this the right way to close sqlite database.I am not sure i am right because later i get error unable to open database.?</p>