I have a table like sampleDB.execSQL("CREATE TABLE IF NOT EXISTS " + SWITCH_TABLE_NAME + "(SwitchID integer primary key autoincrement,SwitchName VARCHAR,RoomID integer,RoomName VARCHAR);");
sampleDB.execSQL("INSERT INTO " + SWITCH_TABLE_NAME + " Values (null,'"+switchName+"','"+roomID+"','"+roomName +"');"); Now I want list of all switchName whose roomId say suppose 3. How to do this? -- You received this message because you are subscribed to the Google Groups "Android Developers" group. To post to this group, send email to android-developers@googlegroups.com To unsubscribe from this group, send email to android-developers+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/android-developers?hl=en