This is my Helper class..i try to add data but i get no such table error.
If we use normal sql query it working.. But this type query not working. how to write these type query please explain that syntax..
static class EmpHelper extends SQLiteOpenHelper{
private static final String DATABASE_NAME = "empdatabase";
private static final String TABLE_NAME = "emptable";
private static final int DATABASE_VERSION = 2;
private static final String UID = "_id";
private static final String NAME = "Name";
private static final String PASSWORD = "Password";
private static final String CREATE_TABLE = "CREATE TABLE" + TABLE_NAME
+ "("+UID+ " INTEGER PRIMARY KEY AUTOINCREMENT," + NAME
+ " VARCHAR(255)," + PASSWORD + "VARCHAR2(255)"+")";
private static final String DROP_TABLE = "DROP TABLE IF EXISTS"
+ TABLE_NAME;
private Context context;
public EmpHelper(Context context) {
super(context, DATABASE_NAME, null, DATABASE_VERSION);
this.context = context;
Message.message(context, "constructor called");
}
@Override
public void onCreate(SQLiteDatabase db) {
// TODO Auto-generated method stub
try {
db.execSQL(CREATE_TABLE);
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
0 comments:
Post a Comment