vendredi 3 juillet 2015

SQLite 'No such table error'

I am trying to create tables in my DBhelper class and I'm continually getting this error: "No table created PAYEES".

Because of this, the rest of the DB operations are also not working. I have put sufficient time on proof reading my CreateTableQuries. Here is one of my queries that fail:

private static final  String tbl3_create_string="CREATE TABLE "+tbl3_name+" ( "+col1_tbl3_name+" INTEGER PRIMARY KEY AUTOINCREMENT, " +
            col2_tbl3_name+" TEXT, "+col3_tbl1_name+" TEXT )";

db.execSQL(tbl3_create_string);

When I check this on SQLite's query validator it is working.

Aucun commentaire:

Enregistrer un commentaire