Sorry in subject line I say 'arrange primary key in ascending order' but roomID is not primary key.
On Nov 17, 8:34 am, "pramod.deore" <[email protected]> wrote: > I have a table like this > > public void insertToSwitchTable(String switchName,int roomID,String > roomName) > { > 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 to arrange the records according to ascending order of > RoomID. How to do this? > > Thanks. -- 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
