Android SQLite Delete row issue

Question

I am trying to delete a row from a table but i have three WHERE clauses and i am not sure if i am using the correct statement.

    db.delete(DBAdapter.TableName, "Id="+ Id
          +" AND WHERE QstnrId = "+Integer.parseInt(QuestionnaireId)
          +" AND WHERE QstnId = "+Integer.parseInt(QuestionId), null);

I am almost certain i am not using the statement correctly. Please assist?

is your tablename correct? Is your Id field unique? (if so, why the extra QstnrId and QstnId?) — Nanne
– Nanne, Commented Jan 31, 2011 at 11:10

Marcelo Cantos · Accepted Answer · 2011-01-31 11:16:16Z

23

You don't need to use the WHERE keyword. Also you could try using the third parameter to delete():

db.delete(DBAdapter.TableName, "Id=? AND QstnrId=? AND QstnId=?",
          new String[] { Id.toString(), QuestionnaireId, QuestionId });

edited Jan 31, 2011 at 11:16

answered Jan 31, 2011 at 11:09

Marcelo Cantos

187k40 gold badges338 silver badges366 bronze badges

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

1 Comment

Beginner Over a year ago

sorry yeh i think that works, i am not passing down the correct values into the id fields

Collectives™ on Stack Overflow

Android SQLite Delete row issue

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related