Column Not found :android.database.sqlLite.SQLiteException : noSuchColumn : myDate(Code 1)
<p>I was able to insert data in to SQLite table but while retrieving its throwing error, changed database version and all below is my error</p>

<pre><code>public String[] GetTotalFifteenDayRAnge() {
        ArrayList&lt;String&gt; objArray = new ArrayList&lt;String&gt;();
        Cursor objCursor = objDatabase.query(Constants.TotalByRange, new String[]{"myDate"}, null, null, null, null, null);

        //  Cursor objCursor= objDatabase.rawQuery("SELECT myDate FROM  TotalByRange ",null);
        while (objCursor.moveToNext()) {               
            objArray.add(objCursor.getString(objCursor.getColumnIndex("myDate")));
        }
        return (String[]) objArray.toArray(new String[objArray.size()]);
    }
</code></pre>

<p>when I tried that raw query its not throwing error but no data in it.Below is the code which I have used for inserting </p>

<pre><code>public void InsertTotalCaloriesByRange(double id, String myDate) {
        ContentValues objContentValues = new ContentValues();
        objContentValues.put("Id", id);
        objContentValues.put("myDate", myDate);

        objDatabase.insert(Constants.TotalByRange, null, objContentValues);

    }
</code></pre>

<p>Exact error is  : "android.database.sqlLite.SQLiteException : noSuchColumn : myDate(Code 1) : , while compiling : select myDate FROM TotalByRange"</p>