CODEWITHSUNDEEP
javaandroidsqlite
user3336747
user3336747

Reputation: 23

Variable error of SQLite in Android

There is some error on my SQLite.

03-18 16:12:09.720: E/SQLiteLog(27137): (1) near "type": syntax error
03-18 16:12:09.720: W/dalvikvm(27137): threadid=1: thread exiting with uncaught exception (group=0x40c20450)
03-18 16:12:09.740: E/AndroidRuntime(27137): FATAL EXCEPTION: main

public void onCreate(SQLiteDatabase db) {
    String CREATE_OWNER_TABLE = "CREATE TABLE " + TABLE_BUS + "(" + KEY_ROUTE + " TEXT NOT NULL," + KEY_DESTINATION + " TEXT NOT NULL," + KEY_FEE + " TEXT NOT NULL " + KEY_TYPE + " TEXT NOT NULL " + KEY_VIA1 + " TEXT NOT NULL " + KEY_VIA2 + " TEXT NOT NULL " + KEY_VIA3 + " TEXT NOT NULL );";
    db.execSQL(CREATE_OWNER_TABLE);
}

Upvotes: 0

Views: 65

Answers (3)

Sekhar Madhiyazhagan
Sekhar Madhiyazhagan

Reputation: 889

please insert commas as below,

     public void onCreate(SQLiteDatabase db) {
String CREATE_OWNER_TABLE = "CREATE TABLE " + TABLE_BUS + "(" + KEY_ROUTE + " TEXT NOT NULL," + KEY_DESTINATION + " TEXT NOT NULL," + KEY_FEE + " TEXT NOT NULL, " + KEY_TYPE + " TEXT NOT NULL ," + KEY_VIA1 + " TEXT NOT NULL ," + KEY_VIA2 + " TEXT NOT NULL, " + KEY_VIA3 + " TEXT NOT NULL );";
db.execSQL(CREATE_OWNER_TABLE);

}

Upvotes: 0

Lucifer
Lucifer

Reputation: 29672

There should be a comma between two column declaration like below, 

public void onCreate(SQLiteDatabase db) 
{
    String CREATE_OWNER_TABLE = "CREATE TABLE " + TABLE_BUS + "(" + KEY_ROUTE + " TEXT NOT NULL," +
             KEY_DESTINATION + " TEXT NOT NULL," + 
             KEY_FEE + " TEXT NOT NULL ," +   // Missing comma here
             KEY_TYPE + " TEXT NOT NULL ," +  // Missing comma here
             KEY_VIA1 + " TEXT NOT NULL ," +  // Missing comma here
             KEY_VIA2 + " TEXT NOT NULL ," +  // Missing comma here
             KEY_VIA3 + " TEXT NOT NULL );";
    db.execSQL(CREATE_OWNER_TABLE);
}

Upvotes: 2

Rey Libutan
Rey Libutan

Reputation: 5314

You are missing commas.

public void onCreate(SQLiteDatabase db) {
    String CREATE_OWNER_TABLE = "CREATE TABLE " + TABLE_BUS + "(" + KEY_ROUTE + " TEXT NOT NULL," + KEY_DESTINATION + " TEXT NOT NULL," + KEY_FEE + " TEXT NOT NULL, " + KEY_TYPE + " TEXT NOT NULL, " + KEY_VIA1 + " TEXT NOT NULL, " + KEY_VIA2 + " TEXT NOT NULL, " + KEY_VIA3 + " TEXT NOT NULL );";
    db.execSQL(CREATE_OWNER_TABLE);
}

Upvotes: 2

Related Questions