I am storing an integer in a database and calling it into another class. When I retrieve it, the integer is getting truncated - so 110 becomes 1, 230 becomes 2, 470 becomes 4, etc.
I tried both "long" and "int" in the code and both have the same results. What am I doing wrong?

Here is the relevant database helper class code:

Code: Select all

public long createNote(String username, String comment, int playerscore) {
        ContentValues initialValues = new ContentValues();
        initialValues.put(KEY_username, username);
        initialValues.put(KEY_comment, comment);
        initialValues.put(KEY_score, playerscore);
        return mDb.insert(DATABASE_TABLE, null, initialValues);
    }

public Cursor fetchNote(long rowId) throws SQLException {
        Cursor result = mDb.query(true, DATABASE_TABLE, new String[] {
                KEY_ROWID, KEY_username, KEY_comment, KEY_score}, KEY_ROWID + "=" + rowId, null, null,
                null, null);
        if ((result.count() == 0) || !result.first()) {
            throw new SQLException("No note matching ID: " + rowId);
        }
        return result;
    }


And here is the relevant code from the class that is using the database to store and retrieve info:

Code: Select all

   
        dbhelper.createNote(userName, userComment, score);


Code: Select all

       Cursor c = dbhelper.fetchNote(userNumber);
       thisusersname = c.getString(c.getColumnIndex(dbhelper.KEY_username));
       thisuserscomment = c.getString(c.getColumnIndex(dbhelper.KEY_comment));
       thisuserscore = c.getInt(c.getColumnIndex(dbhelper.KEY_score));

Hi ramgraph1.
I have not checked the documentation about the database, but in a previous post I noticed that you are creating your table using a 'text' type for all fields, but when fetching data, you are trying to fetch an 'int' or 'long' type.

It is not possible to create the 'score' field in the database as INTEGER or any other numeric type ?

Regards,

OK. I understand better what that create table code is saying now. I should have caught that!
Thanks for answering that for me!