You cannot in this case. This is a mandatory requirement. "pramod.deore" <[email protected]> wrote:
>Hi Bibek, Thanks for reply. But my table RoomTable have only three >columns, RoomID, RoomName, and RoomSuffix. It doesn't have _id field. >Then how to use Cursor Adapter here. > >On Dec 3, 11:55 am, Kumar Bibek <[email protected]> wrote: >> Cursor Adapters require the table to have a _id field. Else, you would get >> this exception. >> Kumar Bibekhttp://techdroid.kbeanie.comhttp://www.kbeanie.com >> >> On Fri, Dec 3, 2010 at 11:15 AM, pramod.deore >> <[email protected]>wrote: >> >> > Hi Everyone, >> >> > I have a table and I want to retrieve one column (RoomName) from this >> > table and display it as a list. had tried it but it gives me >> > exception as " java.lang.IllegalArgumentException: column '_id' does >> > not exist" >> >> > My .java class is >> >> > public class RemoveRoom extends Activity >> > { >> > SQLiteDatabase sampleDB = null; >> > String SAMPLE_DBNAME = "HomeAutoDataBase"; >> > String ROOM_TABLE_NAME = "RoomTable"; >> > String SWITCH_TABLE_NAME = "SwitchTable"; >> > protected ListAdapter adapter; >> > protected ListView roomList; >> >> > @Override >> > public void onCreate(Bundle savedInstanceState) >> > { >> > System.out.println ("First statement in RemoveRoom"); >> > super.onCreate(savedInstanceState); >> > setContentView(R.layout.roomlist); >> > roomList = (ListView) findViewById (R.id.list); >> > displayRoomList(); >> >> > } >> >> > public void displayRoomList() >> > { >> > try >> > { >> > sampleDB = this.openOrCreateDatabase(SAMPLE_DBNAME, >> > MODE_PRIVATE, null); >> > Cursor c = sampleDB.rawQuery("SELECT RoomName FROM " >> > +ROOM_TABLE_NAME, null); >> > System.out.println ("Total number of rooms >> > are"+c.getCount()); >> >> > adapter = new SimpleCursorAdapter( >> > this, >> > R.layout.roomlist, >> > c, >> > new String[] {"RoomName"}, >> > new int[] {R.id.roomname}); //here I got >> > exception >> > roomList.setAdapter(adapter); >> >> > } >> > catch (Exception e) >> > { >> > e.printStackTrace(); >> > } >> > } >> >> > } >> >> > my .xml file is >> >> > <?xml version="1.0" encoding="utf-8"?> >> > <LinearLayout xmlns:android="http://schemas.android.com/apk/res/ >> > android" >> > android:orientation="vertical" >> > android:layout_width="fill_parent" >> > android:layout_height="fill_parent"> >> >> > <ListView >> > android:id="@+id/list" >> > android:layout_width="fill_parent" >> > android:layout_height="fill_parent"/> >> >> > <TextView >> > android:id="@+id/roomname" >> > android:layout_width="wrap_content" >> > android:layout_height="wrap_content"/> >> >> > </LinearLayout> >> >> > And my logcat gives me >> >> > 12-03 10:48:03.540: WARN/System.err(573): >> > java.lang.IllegalArgumentException: column '_id' does not exist >> > 12-03 10:48:03.560: WARN/System.err(573): at >> > android.database.AbstractCursor.getColumnIndexOrThrow(AbstractCursor.java: >> > 314) >> > 12-03 10:48:03.570: WARN/System.err(573): at >> > android.widget.CursorAdapter.init(CursorAdapter.java:111) >> > 12-03 10:48:03.580: WARN/System.err(573): at >> > android.widget.CursorAdapter.<init>(CursorAdapter.java:90) >> > 12-03 10:48:03.589: WARN/System.err(573): at >> > android.widget.ResourceCursorAdapter.<init>(ResourceCursorAdapter.java: >> > 47) >> > 12-03 10:48:03.600: WARN/System.err(573): at >> > android.widget.SimpleCursorAdapter.<init>(SimpleCursorAdapter.java:88) >> > 12-03 10:48:03.611: WARN/System.err(573): at >> > com.monarch.home.RemoveRoom.displayRoomList(RemoveRoom.java:47) >> > 12-03 10:48:03.640: WARN/System.err(573): at >> > com.monarch.home.RemoveRoom.onCreate(RemoveRoom.java:29) >> > 12-03 10:48:03.651: WARN/System.err(573): at >> > android.app.Instrumentation.callActivityOnCreate(Instrumentation.java: >> > 1047) >> > 12-03 10:48:03.660: WARN/System.err(573): at >> > android.app.ActivityThread.performLaunchActivity(ActivityThread.java: >> > 2459) >> > 12-03 10:48:03.669: WARN/System.err(573): at >> > android.app.ActivityThread.handleLaunchActivity(ActivityThread.java: >> > 2512) >> > 12-03 10:48:03.679: WARN/System.err(573): at >> > android.app.ActivityThread.access$2200(ActivityThread.java:119) >> > 12-03 10:48:03.700: WARN/System.err(573): at >> > android.app.ActivityThread$H.handleMessage(ActivityThread.java:1863) >> > 12-03 10:48:03.710: WARN/System.err(573): at >> > android.os.Handler.dispatchMessage(Handler.java:99) >> > 12-03 10:48:03.710: WARN/System.err(573): at >> > android.os.Looper.loop(Looper.java:123) >> > 12-03 10:48:03.720: WARN/System.err(573): at >> > android.app.ActivityThread.main(ActivityThread.java:4363) >> > 12-03 10:48:03.730: WARN/System.err(573): at >> > java.lang.reflect.Method.invokeNative(Native Method) >> > 12-03 10:48:03.750: WARN/System.err(573): at >> > java.lang.reflect.Method.invoke(Method.java:521) >> > 12-03 10:48:03.770: WARN/System.err(573): at >> > com.android.internal.os.ZygoteInit >> > $MethodAndArgsCaller.run(ZygoteInit.java:860) >> > 12-03 10:48:03.781: WARN/System.err(573): at >> > com.android.internal.os.ZygoteInit.main(ZygoteInit.java:618) >> > 12-03 10:48:03.790: WARN/System.err(573): at >> > dalvik.system.NativeStart.main(Native Method) >> >> > -- >> > 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 -- 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
