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

Reply via email to