public boolean removeMessage(String message){
  SQLiteDatabase db=getWritableDatabase();
  if (db != null && message != null) {
    db.execSQL("UPDATE " + TABLE + " SET "+ COL_DELETED+ "="+ TRUE+ " WHERE "+ COL_MESSAGE+ "='"+ message+ "';");
    return true;
  }
  log.debug("Message not added to store, either message or database is null. [" + message + "]");
  return false;
}

public boolean removeMessage ( String message ) { SQLiteDatabase db = getWritableDatabase ( ) ; if ( db != null && message != null ) { db . execSQL ( "UPDATE " + TABLE + " SET " + COL_DELETED + "=" + TRUE + " WHERE " + COL_MESSAGE + "='" + message + "';" ) ; return true ; } log . debug ( "Message not added to store, either message or database is null. [" + message + "]" ) ; return false ; }
remove the given message from the store , the message data is retained with its deleted state set to true .
