Sandip Armal Patil Sandip Armal Patil - 28 days ago 6
Android Question

How to update table in sqlite?

I have two table first is "TABLE_SUBJECT" and second is "TABLE_CHAPTER".Now i want to

add some column and delete previous. My question is that how to do that. i try to update but

it display previous not new. I need to delete previous and update table with new column.

I change version number but it not working. Please give me hint or reference.

Here is my some code of SQLite:

@Override
public void onCreate(SQLiteDatabase database) {

database.execSQL(DATABASE_CREATE);
database.execSQL(DATABASE_CREATE1);

}

@Override
public void onUpgrade(SQLiteDatabase database, int oldVersion, int newVersion) {
// TODO Auto-generated method stub
Log.w(MySQLiteHelper.class.getName(), "Upgrading database from version "
+ oldVersion + " to " + newVersion
+ ", which will destroy all old data");
database.execSQL("DROP TABLE IF EXISTS " + TABLE_SUBJECT);
database.execSQL("DROP TABLE IF EXISTS" + TABLE_CHAPTER);
onCreate(database);
}

Answer

you try this code

public long update_todo_not(String a, String b, String c, String d,
        String e, String f, String g, String id) {
     ContentValues con = new ContentValues();

     con.put("title", a);
     con.put("description", b);
     con.put("due_date", c);
     con.put("alarm_time", d);
     con.put("category", e);
     con.put("alarm_set",f);
     con.put("priority", g);
     Log.v("priority", g+"");
     return mDb.update(DATABASE_TABLE_TODO_LIST, con, "id ='" + id + "'",null);

}