Read up about simple SQL Statements and then you can use the sampleDB's query method to get a cursor.
On Wed, Nov 17, 2010 at 10:59 AM, pramod.deore <[email protected]>wrote: > 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 [email protected] > To unsubscribe from this group, send email to > [email protected]<android-developers%[email protected]> > For more options, visit this group at > http://groups.google.com/group/android-developers?hl=en -- Kumar Bibek http://techdroid.kbeanie.com http://www.kbeanie.com -- You received this message because you are subscribed to the Google Groups "Android Developers" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/android-developers?hl=en
