Delete query not working (db.delete, db.exectSQL, db.rawQuery....)

Question

I am trying to remove certain rows of a table in Android. I tried running directly through the SQL command "execSQL" and "rawQuery". Right now I'm using "db.delete" where I step in the argument "where" the rows that I want to remove.

This is the code:

String where = DBTables.TActivities.ID + " NOT IN ( " +
                " SELECT " + DBTables.TInscripcionesActividades.ID_ACTIVIDAD + " FROM " +DBTables.TInscripcionesActividades.TABLE_NAME + " );";

db.beginTransaction();
db.delete(DBTables.TActivities.TABLE_NAME, where, null);
db.endTransaction();

I tested the sql petition in a BBDD browser and it works fine.

I want to delete all records of the table "TActividades" except the activities whose IDs are in the "TInscripcionesActividades" table.

Any ideas?? Thanks in advance!

Show us how you instantiated your db object. Also what do you mean by not-working? Are you seeing any error? — dsharew, Nov 17 '15 at 08:03
No, any error but rows are not removed. Object db is properly instantiated as all remaining requests are working properly. — Alejandro Martínez Martínez, Nov 17 '15 at 08:06

score 3 · Accepted Answer · answered Nov 17 '15 at 08:11

3

You need to call setTransactionSuccessful() before endTransaction() for the changes to take effect.

answered Nov 17 '15 at 08:11

laalto

150,114
66
286
303

score 2 · Answer 2 · answered Nov 17 '15 at 08:12

String where = DBTables.TActivities.ID + " NOT IN ( " +
                " SELECT " + DBTables.TInscripcionesActividades.ID_ACTIVIDAD + " FROM " +DBTables.TInscripcionesActividades.TABLE_NAME + " );";

db.beginTransaction();
db.delete(DBTables.TActivities.TABLE_NAME, where, null);
db.setTransactionSuccessful();
db.endTransaction();

Delete query not working (db.delete, db.exectSQL, db.rawQuery....)

2 Answers2