how to fix compiler error for sqlite database in android

Question

having problem with this line of code, compiler error on getInt method. because the variable KEY_HITS is a String and not an int. How do I fix this problem?

 total = total + c.getInt(KEY_HITS);

here is more of the code;

    public static final String KEY_ROWID="_id";
    public static final String KEY_NAME="persons_name";
    public static final String KEY_HITS="persons_hits";

 public int getTotal() {

String[] columns = new String[] { KEY_ROWID, KEY_NAME, KEY_HITS };
Cursor c = ourDatabase.query(DATABASE_TABLE, columns, null, null, null,
        null, null);
int total = 0;

for (c.moveToFirst(); !c.isAfterLast(); c.moveToNext()) {
    total = total + c.getInt(KEY_HITS);
}
return total;
 }

Mohammed Azharuddin Shaikh · Accepted Answer · 2013-01-25 06:41:07Z

1

Do what errors says because the variable KEY_HITS is a String and not an int
you need to pass integer parameter in getInt(). You can get column's index by getColumnIndex()

total = total + c.getInt(c.getColumnIndex(KEY_HITS));

edited Jan 25, 2013 at 6:41

answered Jan 25, 2013 at 6:35

Mohammed Azharuddin Shaikh

42.1k14 gold badges98 silver badges117 bronze badges

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

Collectives™ on Stack Overflow

how to fix compiler error for sqlite database in android

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