Cursor : get the field value (Android)
<p>I have problems with Cursor in my Android application.
I have a SQLiteDatabase that return me Cursor when I try to fetch the values with :</p>

<pre>
 public Cursor fetchOption(long rowId) throws SQLException {

        Cursor mCursor =

                mDb.query(true, DATABASE_TABLE, new String[] {KEY_ROWID,
                        KEY_TITLE, KEY_BODY}, KEY_ROWID + "=" + rowId, null,
                        null, null, null, null);
        if (mCursor != null) {
            mCursor.moveToFirst();
        }
        return mCursor;

    }
</pre>

<p>But I don't know how to obtain the value of the field in the Cursor.
If I do that :</p>

<pre>
String a = mOptionDb.fetchOption(0).getColumnName(0).toString();
String b = mOptionDb.fetchOption(0).getColumnName(1).toString();
String c = mOptionDb.fetchOption(0).getColumnName(2).toString();
</pre>

<p>I obtain the name of the columns (_id, title, body) but not the value.
How can I resolve that?</p>

<p>Thank you in advance for your answer.
Michaël</p>
