Android SQLite Delete Row From Table Where 2 Arguments

Question

This is my database :

// the names for database columns
    public final static String TABLE_NAME = "vremena";
    public final static String TABLE_COLUMN_ID = "_id";
    public final static String TABLE_COLUMN_ONE = "dan";
    public final static String TABLE_COLUMN_TWO = "vrijeme";

I'm trying to create a method which takes 2 arguments and deletes a selected row from the database :

public void delete(String dan, int vrijeme){
    db.delete(TABLE_NAME, TABLE_COLUMN_ONE+"="+dan, TABLE_COLUMN_TWO+"="+vrijeme);
    }

Am getting this error :

The method delete(String, String, String[]) in the type SQLiteDatabase is not applicable for the arguments (String, String, String)

I know I'm doing something wrong within delete method.

Ridcully · Accepted Answer · 2013-03-20 12:33:30Z

27

Have a look at the API Docs:

http://developer.android.com/reference/android/database/sqlite/SQLiteDatabase.html

delete(String table, String whereClause, String[] whereArgs)
Convenience method for deleting rows in the database.

You should do this:

public void delete(String dan, int vrijeme){
    db.delete(TABLE_NAME, 
            TABLE_COLUMN_ONE + " = ? AND " + TABLE_COLUMN_TWO + " = ?", 
            new String[] {dan, vrijeme+""});
}

answered Mar 20, 2013 at 12:33

Ridcully

23.7k8 gold badges76 silver badges88 bronze badges

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

Collectives™ on Stack Overflow

Android SQLite Delete Row From Table Where 2 Arguments

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related