I have a strange issue where I cannot delete from my SQLite DB.
I've created a table with this: (note uniqueID as a column)
stat.text = "CREATE TABLE IF NOT EXISTS tablename (id INTEGER PRIMARY KEY AUTOINCREMENT, title TEXT, uniqueID TEXT)";
and can successfully add a record. But when I come to delete the record with:
stat.text = "DELETE FROM tablename WHERE uniqueID = _1234567";
I get an error #3115: no such column: '_1234567'
Somehow the SQL statement is seeing the uniqueID value as the column name.
Am I missing something here?