title: update method in sqlite didn't throw Exception?
body: <p>I'm getting information about items from the web and I want my app to check if certain rows exist. If they do exist then the app should update those rows, otherwise it should create new rows:</p>
  
  <pre><code>try {
      mDb.execSQL("UPDATE ["
      + ParseReciverAddList.tableName
      + "] SET purchased = " + pCheck
      + " WHERE id =" + (thisId));
      mDb.execSQL("UPDATE ["
      + ParseReciverAddList.tableName
      + "] SET name = '" + (PName)
      + "' WHERE id =" + (thisId));
      mDb.execSQL("UPDATE ["
      + ParseReciverAddList.tableName
      + "] SET quantity = '" + (pQuantity)
      + "' WHERE id =" + (thisId));
      Log.d("p", "e");
  } catch (Exception e) {
      Log.d("p", "ne");
      mDb.execSQL("INSERT INTO ["+ParseReciverAddList.tableName+"] VALUES ("+thisId+","+pCheck+", '"+PName+"','"+pQuantity+"');");
  }
  </code></pre>
  
  <p>I figure I'll try to update it and if it throws <code>Exception</code> then it means the rows don't exist and it will create it.</p>
  
  <p>However, I'm running into a problem: even if the row doesn't exist it doesn't throw <code>Exception</code>. Any ideas as to why it's not triggering the <code>catch</code> clause when the rows already exist?</p>