SQLite cannot read field in table

Question

I have a sqlite file

CREATE TABLE `mall` (
    `id`    INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
    `name`  TEXT NOT NULL,
    `kordinat`  TEXT NOT NULL
);

this is select code

cursor = db.rawQuery("SELECT name FROM mall", null);
cursor.moveToFirst();

when I run those code, It work, but when I change "name" field to "kordinat" field, it error and says "no such column: kordinat". please help

**1** - Remove these useless **`** characters. **2** - uninstall and reinstall you app. — Phantômaxx, May 23 '18 at 22:18
uninstall and install it again, you probabelly changed the database schema without upgrading — E.Abdel, May 23 '18 at 22:23

score 0 · Accepted Answer · answered May 23 '18 at 22:37

no such column: kordinat

This is because at first time mall table is created with column name and when you are changing it to kordinat, you are trying to create the table with same name but different schema, so this is not creating the table because table with that name already exists with previous schema.

Uninstall the application and Re-Install the application to you Debugging device.

SQLite cannot read field in table

1 Answers1