KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
Possible Duplicate: SQLite in Android How to update a specific row Is it possible to update database for one column using where statment And this was my table structure and i need to update "messagestatus" column using "id". db.execSQL("CREATE TABLE IF NOT EXISTS autosms(id INTEGER PRIMARY KEY AUTOINCREMENT ,phonenumber VARCHAR(15) ,message VARCHAR(5000) , year VARCHAR(10) , month VARCHAR(10) , date VARCHAR(10) , hour VARCHAR(10) , minute VARCHAR(10) , messagestatus VARCHAR(10))"); I tried with this, but with out Success theres an warning "No such column Send" public void update(int id) { String s = "Send"; db= SQLiteDatabase.openDatabase("data/data/com.example.schduled_messages/SMS_Schdule_Sample.db", null, SQLiteDatabase.CREATE_IF_NECESSARY); db.execSQL("UPDATE autosms SET messagestatus="+s+" WHERE id="+id+""); } Thanks in Advance..
Tags (comma-separated)
Save Edits
Cancel