Android SQLite query: "queryNumEntries .. is not applicable for the arguments"?

Question

I have a database named contacts.db with a table named TABLE_NAME that has one column named Contactname. I want to format a query to check if a contact name that I have as a value in the String variable name is already saved as a record in the table and if it isn't then I want to add it, or else do nothing. The code that I wrote is as follows:

SQLiteDatabase db = events.getReadableDatabase();
int rawNum = DatabaseUtils.queryNumEntries(db, TABLE_NAME, 
                        "Contactname=?", new String[] {contactName}); 
    if(rawNum==0){
        addRecord(contactName);
        addedCounter+=1;
    }
    else{
        savedCounter+=1;
    }

But the app is forced to close. Can you see anything wrong with the query? What I do is to see whether there are any rows and if the number of rows is 0 then to add the contact.

This can be written using a single SQL[ite] query: no need to check the results. Try searching for "the intent" on SO. — user166390
– user166390, Commented Jun 26, 2012 at 18:01
I get The method queryNumEntries(SQLiteDatabase, String) in the type DatabaseUtils is not applicable for the arguments (SQLiteDatabase, String, String, String[]) — APOSTOLOS
– APOSTOLOS, Commented Jun 26, 2012 at 18:04
That's a compile time error that says: I take (SQLiteDatabase, String), but I was given (SQLiteDatabase, String, String, String[]). Time to go back to the API. — user166390
– user166390, Commented Jun 26, 2012 at 18:08

David Cheung · Accepted Answer · 2012-06-26 18:22:37Z

4

Perhaps it's time to update your development kit.

The method with the signature used in the code was introduced with API Level 11:

public static long queryNumEntries (SQLiteDatabase db, String table, String selection, String[] selectionArgs)

API Level 1 had only the two-argument method:

public static long queryNumEntries (SQLiteDatabase db, String table)

edited Jun 26, 2012 at 18:22

user166390

answered Jun 26, 2012 at 18:18

David Cheung

8584 silver badges8 bronze badges

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

Collectives™ on Stack Overflow

Android SQLite query: "queryNumEntries .. is not applicable for the 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