Indeed, you can use execSQL for statements like CREATE, UPDATE, DELETE, INSERT. For SELECT you have to use query.
Best regards, Filip Havlicek 2010/11/11 Daniel Drozdzewski <[email protected]> > On Thu, Nov 11, 2010 at 11:17 AM, pramod.deore <[email protected]> > wrote: > > Hi, Daniel and Filip Thanks for reply. > > after changing query as > > sampleDB.execSQL("SELECT RoomID FROM " +ROOM_TABLE_NAME+" where > > RoomName='"+selectedRoom + "'"); > > > > Now logcat gives following warning > > > > 11-11 16:44:42.298: WARN/System.err(772): > > android.database.sqlite.SQLiteException: unknown error: Queries cannot > > be performed using execSQL(), use query() instead. > > ^^^^^ above is your answer ^^^^^ > > -- > Daniel > > -- > 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 > -- 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
