This might be a dumb question, but I&#39;m new to SQLite and I can&#39;t seem to figure this out.  I have 1 table that has columns `KEY_ROWID`, `KEY_NAME`, `KAY_LATITUDE`, and `KEY_LONGITUDE`.  I want the user to be able to select one and delete it; Can anyone give me a direction to start in?  My question is in the actual deletion of the row given only its name.

Relevant code:

    public class BeaconDatabase {

    	public static final String KEY_ROWID = &quot;_id&quot;;
    	public static final String KEY_NAME = &quot;beacon_name&quot;;
    	public static final String KEY_LATITUDE = &quot;beacon_lat&quot;;
    	public static final String KEY_LONGITUDE = &quot;beacon_lon&quot;;
    
    	private static final String DATABASE_NAME =&quot;BeaconDatabase&quot;;
    	private static final String DATABASE_TABLE =&quot;beaconTable&quot;;
    	private static final int DATABASE_VERSION = 1;
    	
    	private DbHelper helper;
    	private final Context context;
    	private SQLiteDatabase db;
    	
    	public BeaconDatabase(Context context) {
    		this.context = context;
    	}
    	
    	public BeaconDatabase open() {
    		helper = new DbHelper(this.context);
    		db = helper.getWritableDatabase();
    		return this;
    	}
    	
    	public void close() {
    		helper.close();
    	}
    	
    	public long createEntry(String name, Double lat, Double lon) {
    		ContentValues cv = new ContentValues();
    		cv.put(KEY_NAME, name);
    		cv.put(KEY_LATITUDE, lat);
    		cv.put(KEY_LONGITUDE, lon);
    		return db.insert(DATABASE_TABLE, null, cv);
    	}
    	
    	public void deleteEntry(long row) {
    		
                  // Deletes a row given its rowId, but I want to be able to pass
                  // in the name of the KEY_NAME and have it delete that row.
                  //db.delete(DATABASE_TABLE, KEY_ROWID + &quot;=&quot; + row, null);
    	}
    	
    	public String getData() {
    		String[] columns = { KEY_ROWID, KEY_NAME, KEY_LATITUDE, KEY_LONGITUDE };
    		Cursor cursor = db.query(DATABASE_TABLE, columns, null, null, null, null, null);
    		String result = &quot;&quot;;
    		
    		int iRow = cursor.getColumnIndex(KEY_ROWID);
    		int iName = cursor.getColumnIndex(KEY_NAME);
    		int iLat = cursor.getColumnIndex(KEY_LATITUDE);
    		int iLon = cursor.getColumnIndex(KEY_LONGITUDE);
    		
    		for (cursor.moveToFirst(); !cursor.isAfterLast(); cursor.moveToNext()) {
    			result += cursor.getString(iRow) + &quot;: &quot; + cursor.getString(iName) + &quot; - &quot; + cursor.getDouble(iLat) + &quot; latitude &quot; + cursor.getDouble(iLon) + &quot; longitude\n&quot;;
    		}
    		
    		return result;
    		
    	}
    	
    	private static class DbHelper extends SQLiteOpenHelper {
    
    		public DbHelper(Context context) {
    			super(context, DATABASE_NAME, null, DATABASE_VERSION);
    		}
    
    		@Override
    		public void onCreate(SQLiteDatabase db) {
    			db.execSQL(&quot;CREATE TABLE &quot; +  DATABASE_TABLE + &quot; (&quot; + 
    					KEY_ROWID + &quot; INTEGER PRIMARY KEY AUTOINCREMENT, &quot; +
    					KEY_NAME + &quot; TEXT NOT NULL, &quot; +
    					KEY_LATITUDE + &quot; DOUBLE, &quot; +
    					KEY_LONGITUDE + &quot; DOUBLE);&quot;
    			);
    		}
    
    		@Override
    		public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
    			db.execSQL(&quot;DROP TABLE IF EXISTS &quot; + DATABASE_TABLE);
    			onCreate(db);
    		}
    	}
    }



All Corresponding Records Solutions on Gang of Coders

Total of 1 Corresponding Records Solutions

Deleting Row in SQLite in Android