Issue with SQLite query?
<p>First. verry sorry about my english. if you dont understand what i mean pls notice me.
i have a problem with this code, but I dont know why</p>

<pre><code>public Cursor fetchReminderByMaterial(String table_name, String label, String key_material_name) throws SQLException {
    Cursor mCursor = mDb.query(true, table_name, null, key_material_name + "=" + label, null, null, null, null, null);
    if (mCursor != null) {
        mCursor.moveToFirst();
    }
    return mCursor;
}
</code></pre>

<p>I have an error like <code>no such column label</code>.<br>
how can I solve it?</p>

<p>update
this is my fuction to creating table</p>

<pre><code>String conectionSql = "CREATE TABLE IF NOT EXISTS "+ DATABASE_CONNECTION_TABLE +"(";
                            conectionSql += ""+ KEY_ROWID +" INTEGER PRIMARY KEY AUTOINCREMENT,";
                            conectionSql += ""+ KEY_FOOD_NAME +",";
                            conectionSql += ""+ KEY_MATERIAL_NAME +")";

    mDbConection.createTable(conectionSql); // Tao bang
</code></pre>

<p>and that is how i use it</p>

<pre><code>Cursor c = mDbConnection.fetchReminderByMaterial(
            DATABASE_CONNECTION_TABLE, "material", KEY_MATERIAL_NAME);
</code></pre>

<p>thank you to listening</p>