Unable to delete a row in SQLite database in my app

Question

I need to delete a specific row from table in my SQLite database.
This table contains paths to files.
And I need to delete paths, which contain specific extensions.
And I have troubles with this.
Nothing is deleted from my database.

For example my table name is ALL_PATHS and column name is PATH_NAME This is the way I am doing this.
I'll be very glad for any help thanks

private void deletePath(String extension){
    Database db = getWritableDatabase();
    String query = "DELETE FROM " + ALL_PATHS + " WHERE lower(" + PATH_NAME + ") LIKE '%" + extension + "'";
    Cursor cursor = db.rawQuery(query, null);
}

check your query using sqllite tools whether it is correct or not — Vivek Mishra
– Vivek Mishra, Commented Jan 20, 2016 at 10:33

Phantômaxx · Accepted Answer · 2016-01-20 10:33:23Z

5

The error is:

Cursor cursor = db.rawQuery(query, null);

While it should be

db.execSQL(query);

Because DELETE is a command, not a query (SELECT)

answered Jan 20, 2016 at 10:33

Phantômaxx

38.1k21 gold badges88 silver badges122 bronze badges

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

2 Comments

Phantômaxx Over a year ago

I'm glad to know that!

IntelliJ Amiya Over a year ago

@HrundiV.Bakshi Sir , Great

viratpuar · Accepted Answer · 2016-01-20 10:35:48Z

0

use Content values

String table = "beaconTable";
String whereClause = "_id" + "=?";
String[] whereArgs = new String[] { String.valueOf(row) };
db.delete(table, whereClause, whereArgs);

answered Jan 20, 2016 at 10:35

viratpuar

5541 gold badge5 silver badges22 bronze badges

1 Comment

bukka.wh Over a year ago

But in my case need to delete rows, which contain special extension in path. So i need to use LIKE keyword. And in your case we are checking, if they are equal.

Collectives™ on Stack Overflow

Unable to delete a row in SQLite database in my app

2 Answers 2

2 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related