vendredi 15 janvier 2016

syntax error while compiling SQLite DB (creating a table) whats wrong with my query?

        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