Delete record(s) using a variable with Android SQLite

Posted on 2013-11-28
Medium Priority
Last Modified: 2013-11-29
I can delete row(s) using known TEXT like 'Bill'
db.delete("mytable", "name = 'Bill'", null); ... this works

I want to delete row(s) from a table using a VARIABLE ... what is the syntax ?
The following 3 attempts do not work :
String FirstName = "Bill";
db.delete("mytable", "name = FirstName", null);
db.delete("mytable", "name = String.valueOf(FirstName)", null);
db.delete("mytable", "name=?", FirstName);

Is there a SIMPLE solution ?
Question by:Danimal-K
  • 2
LVL 11

Accepted Solution

Manish earned 2000 total points
ID: 39684716
Try this
String firstName = "Bill";
String columnName="name";

db.delete("mytable", columnName+"="+firstName, null);
LVL 11

Expert Comment

ID: 39684725
or check this
db.delete("mytable", columnName+"=? ", new String[] { firstName });

Author Comment

ID: 39685492
String firstName = "Bill";
String columnName="name";
db.delete("mytable", columnName+"="+firstName, null);
firstName needs to be in single quotes so I tweeked the where statement

db.delete("mytable", columnName+"="+'"+firstName+"', null);

Now it works !!!!
Thank you so much Karanw

Featured Post

The Lifecycle Approach to Managing Security Policy

Managing application connectivity and security policies can be achieved more effectively when following a framework that automates repeatable processes and ensures that the right activities are performed in the right order.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

This article summarizes the problem of addictive cell phone usage that college students across the country are facing. It covers the issues with obsessive cell phone addiction, reasons why this is happening, and what we can do to solve this problem.
Exchange database can often fail to mount thereby halting the work of all users connected to it. Finding out why database isn’t mounting is crucial and getting the server back online. Stellar Phoenix Mailbox Exchange Recovery is a champion product t…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …

588 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question