vendredi 20 février 2015

SQLITE adding a column to pre-existing table

Don't know what's going wrong, I'm still new to SQLITE but I followed the documentation but not going well. I keep getting the error that my accountsTable doesn't exist but everything works fine prior to me trying to add a column. Here's the code I'm trying to use:



db.execSQL("ALTER TABLE accountsTable ADD COLUMN colEditDate TEXT;");


And the error I get



android.database.sqlite.SQLiteException:no such table:accounsTable(code1):, while compiling:ALTER TABLE accountsTable ADD COLUMN colEditDate TEXT;


Syntax issue maybe?


Aucun commentaire:

Enregistrer un commentaire