android update database error

Question

Well I am trying to update a value in database false to true;

this is my code

public void updatecheck( int id){
     mDb = mDbHelper.getWritableDatabase();

       ContentValues newValues = new ContentValues();
       newValues.put("check", true);
       mDb.update(channel, newValues, "id"+" = ?", new String [] {String.valueOf(id)});

}

But I am taking this error,

02-28 15:15:37.515: E/AndroidRuntime(5539): android.database.sqlite.SQLiteException: near "check": syntax error (code 1): , while compiling: UPDATE Genelkultur2012 SET check=? WHERE id = ?

SOLVED:

new codes

 ContentValues newValues = new ContentValues();
         newValues.put("tamam", true);
         mDb.update(channel, newValues, "id"+" = ?", new String [] {String.valueOf(id)});

laalto · Accepted Answer · 2014-02-28 13:24:31Z

3

CHECK is a reserved keyword in SQL. Either rename the column or quote it in backticks.

answered Feb 28, 2014 at 13:24

laalto

153k68 gold badges293 silver badges306 bronze badges

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

Comments

Saket · Accepted Answer · 2014-02-28 13:24:23Z

1

newValues.put("check", true);

You're trying to store true, a Boolean data type, which is not supported by SQLite. You'll instead have to store them in one of the following types:

NULL. The value is a NULL value.
INTEGER. The value is a signed integer, stored in 1, 2, 3, 4, 6, or 8 bytes depending on the magnitude of the value.
REAL. The value is a floating point value, stored as an 8-byte IEEE floating point number.
TEXT. The value is a text string, stored using the database encoding (UTF-8, UTF-16BE or UTF-16LE).
BLOB. The value is a blob of data, stored exactly as it was input.

I'd suggest to store Boolean members as 0 or 1. More info here: http://www.sqlite.org/datatype3.html

answered Feb 28, 2014 at 13:24

Saket

3,1161 gold badge33 silver badges31 bronze badges

3 Comments

mehmet Over a year ago

it looks normal. there is no problem with "true"

mehmet Over a year ago

Actually you were right because boolean makes some problem. I have changed boolean to 0,1 but as a text

Saket Over a year ago

So a boolean data type was indeed causing issues? And oh what type?

Collectives™ on Stack Overflow

android update database error

2 Answers 2

Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related