Android SQLite database delete

Question

I want to delete the all rows by dates. In the table I have the rows with this format:2014-01-01. Now, I want to delete the all rows by date range. I have created this method, but I believe there is a syntax error:

 public void deleteAllEntrate_e_uscite(View v) {
    SQLiteDatabase db = mHelper.getWritableDatabase();
      db.delete(MyTable.TABLE_NAME, MyTable.DATA + "BETWEEN" +dateAndTime+ "AND" +dateAndTime1, null);
    db.close();
    finish(); 

}

Convert String to date. Look at http://stackoverflow.com/q/4428795 — Martín Alcubierre, Mar 29 '15 at 17:44
Asked bazillion times... First spaces... Second apostrophes... But of course you should use parameters... — Selvin, Mar 29 '15 at 17:48

score 1 · Answer 1 · answered Mar 29 '15 at 17:48

1

When concatenating you are not leaving a space between the elements.

db.delete(MyTable.TABLE_NAME, MyTable.DATA + " BETWEEN " +dateAndTime+ " AND " +dateAndTime1, null);

answered Mar 29 '15 at 17:48

Hector Montero

129
2

Yes, exactly as I said. Don't forget to add the apostrophes around the dates, since they are strings. – Phantômaxx Mar 29 '15 at 17:51

score 0 · Accepted Answer · answered Mar 29 '15 at 17:47

0

You need to separate your keywords:

MyTable.DATA + "BETWEEN" +dateAndTime+ "AND" +dateAndTime1

you need spaces AND you need apostrophes, since your dates are strings:

MyTable.DATA + " BETWEEN '" +dateAndTime+ "' AND '" +dateAndTime1 +"'"

answered Mar 29 '15 at 17:47

Phantômaxx

37,901
21
84
115

score 0 · Answer 3 · answered Jul 04 '15 at 10:06

Since you are comparing date(not column of type int),you have to use apostrophes.So the query will be like this.

db.delete(MyTable.TABLE_NAME, MyTable.DATA + "BETWEEN '" +dateAndTime+ "' AND '" +dateAndTime1+"'", null);

Also add one white space between 'BETWEEN' & the DATE PARAMETER.Other wise you will get SQLiteException. One suggestion too,before executing every query please ensure that the db connection(here 'db') is not null.

Android SQLite database delete

3 Answers3