Android SQliteOpenHelper delete statement issue

Question

Trying to refresh a catalog items table .. just a basic database operation I'm stuck with a strange behaviour

String purgeItems ="DELETE FROM CatalogItems";

String count = "SELECT * FROM CatalogItems";

SQLiteDatabase db = mDb.getWritableDatabase(); // mDb extends SQLiteOpenHelper

db.beginTransaction();
db.rawQuery(purgeItems,null);
db.setTransactionSuccessful();
db.endTransaction();

Cursor c = db.rawQuery(count, null);
Log.e(TAG, "CatalogItems after purge " + String.valueOf(c.getCount()));

returns 642 : the original table rows count

... ! perhaps I'm tired ^^. it does work fine with other tables ..

the SQLiteOpenHelper (mDb) creation table code

private void createTables(SQLiteDatabase db) {
    // --- CATALOG ITEMS ---
    String catalogItemsTable = "CREATE TABLE CatalogItems (" +
            "idCatalogItem      INT(11) PRIMARY KEY, " +
            "idCatalog  INT(11), " +
            "idProduct  INT(11), " +
            "image     BLOB, " +
            "price     FLOAT, " +
            "quantity     INT(11), " +
            "unit     VARCHAR(5), " +
            "status  INT(11), " +
            "extras   VARCHAR(512) " +
            ");" ;

db.execSQL(catalogItemsTable);
Log.i(TAG, "table CatalogItems created");

probably you need to put some conditions. DELETE FROM CatalogItems where blabla = 'abc' — Sreehari
– Sreehari, Commented May 7, 2016 at 18:53
replace db.rawQuery(purgeItems,null); with db.execSQL(purgeItems,null); — Phantômaxx
– Phantômaxx, Commented May 7, 2016 at 19:38

Nathanael · Accepted Answer · 2016-05-07 19:11:43Z

1

rawQuery is meant for queries that return rows. Instead use:

db.execSQL(purgeItems);

answered May 7, 2016 at 19:11

Nathanael

7115 silver badges12 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Emmanuel BRUNET Over a year ago

Shame on me !!! .. I'am French and just java "beginner" .. just thought that rawQuery was a real basic method to interpret SQL statements .. Thans a lot ! ^^

Collectives™ on Stack Overflow

Android SQliteOpenHelper delete statement issue

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related