mardi 23 juin 2015

AS3 SQL Lite delete issue

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?

Aucun commentaire:

Enregistrer un commentaire