SQLite, can't delete columns

Question

UPDATE: See self-answer, "fixed, need to channge the where clauses"

I have set a content provider, for some reason I am able to to delete a row this way:

getContentResolver().delete(myUri, "_id=" + "3", null);

but i am not able to delete a row that way:

getContentResolver().delete(myUri, "NAME=" + "chris", null);

getting this error:

02-15 15:48:08.197: ERROR/AndroidRuntime(3043): android.database.sqlite.SQLiteException: no such column: chris: , while compiling: DELETE FROM User WHERE NAME=chris

I have checked my database file, and it is there.. but for some reason i can delete columns from my database only by the _id column,

how can i fix this?

error:

02-15 15:48:08.197: ERROR/AndroidRuntime(3043): android.database.sqlite.SQLiteException: no such column: idanmoshik1: , while compiling: DELETE FROM User WHERE USER_NAME=idanmoshik1

*User is the name of my table.

thanks,

Moshik

f3lix · Accepted Answer · 2010-02-15 16:08:42Z

3

You should add single quotes (') around chris and idanmoshik1 like this

getContentResolver().delete(myUri, "NAME='chris'", null);

answered Feb 15, 2010 at 16:08

f3lix

29.9k11 gold badges68 silver badges87 bronze badges

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

1 Comment

AmyWuGo Over a year ago

Could you explain why? Thank you very much.

Diego Torres Milano · Accepted Answer · 2010-02-15 18:20:45Z

2

Much better, forget about escaping quotes and other subtleties using

final int n = getContentResolver().delete(myUri, "NAME = ?", new String[] {"user's name"});

answered Feb 15, 2010 at 18:20

Diego Torres Milano

69.9k9 gold badges116 silver badges145 bronze badges

Comments

Moshik · Accepted Answer · 2010-02-15 16:07:56Z

0

fixed, need to channge the where clauses

answered Feb 15, 2010 at 16:07

Moshik

5891 gold badge5 silver badges19 bronze badges

1 Comment

Zordid Over a year ago

Why don't you correctly close your question or tag answer 1 or 2 as the correct answers?

Collectives™ on Stack Overflow

SQLite, can't delete columns

3 Answers 3

1 Comment

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related