vendredi 4 septembre 2015

SQLiteException: no such column:, while compiling

This is my db helper class, that creates db when app is installed first time.

When i register a new user , if his name is letters like "john" , it gives me exception, however usernames like 4, 56, i.e. digits only - they give no errors. Why?

class DBHelper extends SQLiteOpenHelper {

public DBHelper(Context context) {
    super(context, "myDB", null, 1);
}

@Override
public void onCreate(SQLiteDatabase db) {
    Log.d("x", " database CREATED!!! -------------------------");
    db.execSQL("create table userData ("
            + "id integer primary key autoincrement,"
            + "name text,"
            + "password text,"
            + "hero int,"
            + "level int,"
            + "loggedin int"
            + ");");
}

@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {

}

}

Aucun commentaire:

Enregistrer un commentaire