public void onCreate(SQLiteDatabase db) {
String query = "CREATE TABLE " + TABLE_INFO + "(" +
COLUMN_ID + " INTEGER PRIMARY KEY " +
COLUMN_DATE + " TEXT " +
COLUMN_DOCNAME + " TEXT " +
COLUMN_SYMP + " TEXT " +
COLUMN_DIGNO + " TEXT " +
COLUMN_MEDS + " TEXT " +
");";
db.execSQL(query);
what is wrong with this? getting the ndroidRuntime: FATAL EXCEPTION: main android.database.sqlite.SQLiteException: near "date": syntax error: , while compiling: CREATE TABLE info(_id INTEGER PRIMARY KEY date TEXT docName TEXT symp TEXT digno TEXT meds TEXT ); error plz help
Aucun commentaire:
Enregistrer un commentaire