IllegalStateException while querying database

[Olajire Abdullahi]

Hi Guys, I was trying to fetch my Database. If I fetch the database sequecially it will work fine,

This is Sequencially of fetching my Database..and It work fine

while(res.moveToNext()){
                         buffer.append("ID: " + " " + res.getString(0) + "\n");
                          buffer.append("Course Code: " +  " " + res.getString(1) + "\n");
                           buffer.append("Lecturer Name: " +  " " + res.getString(2) + "\n");
                            buffer.append("Venue: "  +  " " + res.getString(3) + "\n");
                              buffer.append("Day: " +  " " + res.getString(4) + "\n");
                               buffer.append("Frequency: " +   " " +  res.getString(5) + "\n");
                                 buffer.append("Lecture Time: " +  " " +  res.getString(6) + "\n");
                                   buffer.append("Notify Time: "  +  " " +  res.getString(7) + "\n\n");

                         showM("Available Data" , buffer.toString());

But I only need or want to fetch two or more column in the database...And It display some error(The Error is below this codes)

 while(res.moveToNext()){

                buffer.append(res.getString(1) + " ");
                 buffer.append(res.getString(2) + " ");
                  buffer.append(res.getString(3) + " ");
                   buffer.append(res.getString(7) + " ");

      showM("Available Data" , buffer.toString());

The Error it display......

  java.lang.IllegalStateException: Couldn't read row 0, col 7 from CursorWindow.  Make sure the Cursor is initialized correctly before accessing data from it.
                                                                                  at android.database.CursorWindow.nativeGetString(Native Method)
                                                                                  at android.database.CursorWindow.getString(CursorWindow.java:438)
                                                                                  at android.database.AbstractWindowedCursor.getString(AbstractWindowedCursor.java:66)
                                                                                  at net.obounce.schedulenotifier.SchoolTimetable.Notification(SchoolTimetable.java:318)
                                                                                  at net.obounce.schedulenotifier.SchoolTimetable.onClick(SchoolTimetable.java:234)
                                                                                  at android.view.View.performClick(View.java:6199)
                                                                                  at android.view.View$PerformClick.run(View.java:23235)
                                                                                  at android.os.Handler.handleCallback(Handler.java:836)
                                                                                  at android.os.Handler.dispatchMessage(Handler.java:103)
                                                                                  at android.os.Looper.loop(Looper.java:203)
                                                                                  at android.app.ActivityThread.main(ActivityThread.java:6251)
                                                                                  at java.lang.reflect.Method.invoke(Native Method)
                                                                                  at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:1073)
                                                                                  at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:934)

Please Help me!

[Tim Moores]

In the future, please give your posts more descriptive titles than "Android" or "Android Studio" - in the Android forum, this tells us nothing about what the discussion is all about. I have changed it to something more meaningful - please do so yourself next time.

[Olajire Abdullahi]

Thanks @Tim Moores

[Campbell Ritchie]

What does it say about moving from row to row in your result set? How many columns do you have?
Who on earth taught you to indent code like that?
You may only need to use the identifier buffer once.
Have you been instructed to use the LF character? If not, don't use \n. Use System.lineSeparator() instead. Why are you using ...+ " " +...? You could simply put the additional space in the preceding String literal. If you are using a StringBuilder, you would probably do better to use multiple append() calls than use +.

[Olajire Abdullahi]

Thanks Campbell Ritchie.
Have make some changes to the code but it doesn't display any error when moving from one row to another..but it display error when it reach index of 7...
I have 8 columns. i.e from 0 - 7

[Campbell Ritchie]

Olajire Abdullahi wrote:Thanks Campbell Ritchie.

That's a pleasure

. . .I have 8 columns. i.e from 0 - 7

No, you have eight columns numbered 1...8. Databases use different numbering.

You are getting things out of a result set, aren't you? If not, then I am mistaken about 1...8.

[Dave Tolls]

What is the query you are using?