Variable error of SQLite in Android

Question

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);
}

is there any field name type u are using ?

Shabbir Dhangot
– Shabbir Dhangot

2014-03-18 07:54:25 +00:00
Commented Mar 18, 2014 at 7:54 — Shabbir Dhangot
– Shabbir Dhangot, Commented Mar 18, 2014 at 7:54

CL. · Accepted Answer · 2014-03-18 07:55:49Z

2

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);
}

edited Mar 18, 2014 at 7:55

CL.

182k18 gold badges241 silver badges282 bronze badges

answered Mar 18, 2014 at 7:54

Rey Libutan

5,32210 gold badges44 silver badges75 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Barışcan Kayaoğlu Over a year ago

This guy is the winner here.

Rey Libutan Over a year ago

Please don't forget to choose the answer help you most :)

Lucifer Over a year ago

@user3336747, You should accept this answer by ticking green tick mark besides this answer. This helps others as well.

Lucifer · Accepted Answer · 2014-03-18 07:58:39Z

2

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);
}

answered Mar 18, 2014 at 7:58

Lucifer

29.7k25 gold badges93 silver badges144 bronze badges

Comments

Sekhar Madhiyazhagan · Accepted Answer · 2014-03-18 08:42:41Z

0

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

}

answered Mar 18, 2014 at 8:42

Sekhar Madhiyazhagan

8895 silver badges14 bronze badges

Collectives™ on Stack Overflow

Variable error of SQLite in Android

3 Answers 3

3 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

3 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related