Error when trying to update database in android sqlite

Question

I have a problem on adding subcategories,I want for example as discribed in the table below,to write a method in android that takes the parent id wich is the id of Animal and put it in the column parentid of doggie.

 |   id  |   parentid    |   name    |
-----------------------------------------
|   1    |   null        |   animal   |
|   2    |   null        |vegetable   |
|   3    |   1           |   doggie   |
|   4    |   2           |   carrot   |
|        |               |            |
|        |               |            |

this is my query to create the table in android:

private static final String CREATE_TABLE_CATEGORIES="CREATE TABLE "+TABLE_CATEGORIES+"(id INTEGER PRIMARY KEY AUTOINCREMENT,"+category_name+
            " TEXT,parentid INTEGER null,foreign key (parentid) references "+TABLE_CATEGORIES+" (id));";

then :

public void onCreate(SQLiteDatabase db){
        //Creation required tables


        db.execSQL(CREATE_TABLE_CATEGORIES);

    }

........... ........... ...........

 public void onUpgrade(SQLiteDatabase db,int oldVersion,int newVersion){
        // on upgrade drop older tables
        db.execSQL("PRAGMA foreign_keys = ON;");
        db.execSQL("DROP TABLE IF EXISTS " + CREATE_TABLE_CATEGORIES);
        // create new table
        onCreate(db);
    }

Now I want to link a child categorie with the parent categorie using update.

public void AddSubCategory(Categories parent,Categories child){
        SQLiteDatabase db = this.getWritableDatabase();
        ContentValues values = new ContentValues();
        values.put(String.valueOf(child.getParentid()),parent.getId());
        db.update(TABLE_CATEGORIES,values,KEY_ID + " = ?",new String[] {String.valueOf(child.getId())});


    }

The error:

at dalvik.system.NativeStart.main(Native Method)
     Caused by: android.database.sqlite.SQLiteException: near "0": syntax error (code 1): , while compiling: UPDATE Categories SET 0=? WHERE id = ?
            at android.database.sqlite.SQLiteConnection.nativePrepareStatement(Native Method)

laalto · Accepted Answer · 2014-08-29 10:40:56Z

1

The first argument to ContentValues put() should be the column name such as "parentid" and not a number such as 0 returned by child.getParentid().

answered Aug 29, 2014 at 10:40

laalto

153k68 gold badges293 silver badges306 bronze badges

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

3 Comments

TheGreenGoblen Over a year ago

But what about the String.valueof() method,it doesnt return a String?

TheGreenGoblen Over a year ago

Is there a method to convert the returned int by getParentid(),into String?

laalto Over a year ago

Yes it's a String but the string does not represent a column name.

krshmbb · Accepted Answer · 2014-08-29 12:04:52Z

0

Your update statement should be :

values.put("parentid",parent.getId()); db.update(TABLE_CATEGORIES,values,KEY_ID + " = ?",new String[{String.valueOf(child.getId())});

answered Aug 29, 2014 at 12:04

krshmbb

466 bronze badges

2 Comments

TheGreenGoblen Over a year ago

Yeah thanks that's what I did,but is there a method That gets parentid of the object instead of writing the "parentid"

krshmbb Over a year ago

I'm not sure I get your question completely. "parentid" is the name of the column. If you want to get the parentid of an object, you will need to query your database instead. You can then do something like cursor.getColumnName(int columnIndex)

Collectives™ on Stack Overflow

Error when trying to update database in android sqlite

2 Answers 2

3 Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related