FATAl Exception during delete record from sqlite in Android?

Question

In my database Inbox table have column name path to keep path of files but when i am trying to delete that record on the base of path the FATAL exception is thrown by Emulator.

// Deleting single File
public void deleteFile(File file) {
    SQLiteDatabase db = this.getWritableDatabase();
    db.delete(TABLE_INBOX, KEY_PATH + " = "+file.getPath(),null);
    db.close();
}

Exception is :

FATAL EXCEPTION:main

android.database.sqlite.SQLiteExceprion: unrecognized token:"1kbFile"(code 1):,while compiling :DELETE inbox WHERE path=1kbFile.txt.

1kbFile.txt is path that i want to delete which is already saved in db. how can i solve this?

i.e.: KEY_PATH + " = '"+file.getPath() + "'" if it works I'll make it an official answer — d'alar'cop
– d'alar'cop, Commented Sep 8, 2013 at 19:52

jbihan · Accepted Answer · 2013-09-08 19:58:22Z

1

Try to add ' to your file name, like this :

db.delete(TABLE_INBOX, KEY_PATH + " = '" + file.getPath() + "'", null);

Or you could also try to use separate parameters :

String whereString = KEY_PATH + " = ?";
String[] whereArgs = new String[] {file.getPath()};
db.delete(TABLE_INBOX, whereString, whereArgs);

edited Sep 8, 2013 at 19:58

answered Sep 8, 2013 at 19:52

jbihan

3,0992 gold badges28 silver badges34 bronze badges

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

1 Comment

jbihan Over a year ago

So @user2322360, did that finally help you solve your problem ?

Jacob Nordfalk · Accepted Answer · 2013-09-08 19:52:58Z

0

Use ' around the values. E.g.:

db.delete(TABLE_INBOX, KEY_PATH + " = '"+file.getPath()+"'",null);

answered Sep 8, 2013 at 19:52

Jacob Nordfalk

3,5431 gold badge24 silver badges21 bronze badges

Collectives™ on Stack Overflow

FATAl Exception during delete record from sqlite in Android?

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related