title: No error but data is not getting deleted from Sqlite database using delete
body: <p>I am trying to delete the data from table and was able to write the command but unfortunately data is not getting deleted.. There is no error or exception reported but nothing is happening.</p>
  
  <p>Checked the similar posts in stackoverflow but nothing is helping me and unable to understand where I am going wrong.</p>
  
  <p>Below is my code</p>
  
  <pre><code>Calendar c = Calendar.getInstance();
  c.add(Calendar.MONTH, -0);
  backup_date=((c.get(Calendar.DATE)-1)+"/"+(c.get(Calendar.MONTH)+1)+"/"+c.get(Calendar.YEAR));
  
  System.out.println(backup_date);
                  Database.getInstance(getApplicationContext()).getWritableDatabase().beginTransaction();
                  result=Database.getInstance(getApplicationContext()).getWritableDatabase().delete(tablename, column2 + " &lt; '" + backup_date + "'", null);
                  Database.getInstance(getApplicationContext()).getWritableDatabase().setTransactionSuccessful();
                  if(result!=1){
                      Toast.makeText(getApplicationContext(), "Problem with deletion try again", Toast.LENGTH_LONG).show();
                  }
                  else{
                      System.out.println("deleted successfully");
                      Toast.makeText(getApplicationContext(), "Data deleted successfully for the date " + backup_date, Toast.LENGTH_LONG).show();
                  }
  </code></pre>
  
  <p>Where am I going wrong?</p>