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