CODEWITHSUNDEEP
androidsqlite
user2764693
user2764693

Reputation: 33

Android SQLite error syntax error (code 1)

@Override
public void onCreate(SQLiteDatabase db) {
String CREATE_DATES_TABLE = "CREATE TABLE" + TABLE_NAME + "(" + COLUMN_DATES + "TEXT"+ ")";
    db.execSQL(CREATE_DATES_TABLE);
}

what wrong with syntax ?

Upvotes: 0

Views: 1404

Answers (2)

Zoe - Save the data dump
Zoe - Save the data dump

Reputation: 28288

YOu are missing a space between the column name and column type, which in your case is TEXT. It should be:

String CREATE_DATES_TABLE = "CREATE TABLE " + TABLE_NAME + " (" + COLUMN_DATES + " TEXT)";

And you may want to use "CREATE TABLE IF NOT EXISTS " + TABLE_NAME + "(..... to ensure you don't create the table if it exists(if that is a function you want).

Upvotes: 1

Stephen
Stephen

Reputation: 4249

You are missing space between your keywords and values

String CREATE_DATES_TABLE = "CREATE TABLE" + TABLE_NAME + "(" + COLUMN_DATES + "TEXT"+ ")";

should be

String CREATE_DATES_TABLE = "CREATE TABLE " + TABLE_NAME + " (" + COLUMN_DATES + " TEXT)";

Upvotes: 2

Related Questions