CODEWITHSUNDEEP
androidsqlite
Rocky
Rocky

Reputation: 11

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 AndroidRuntime: 

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.

Please help

Upvotes: 1

Views: 39

Answers (2)

Krishna Satwaji Khandagale
Krishna Satwaji Khandagale

Reputation: 2260

You are missing comma . Add it .

Upvotes: 0

Psypher
Psypher

Reputation: 10829

You have comma missing in the query after each column, change the query string as below:

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 " +
        ");";

Upvotes: 1

Related Questions