SQLiteException: near /TABLE_NAME/: syntax error

Question

please help me. I'm getting this error:

Caused by: android.database.sqlite.SQLiteException: near "values": syntax error: CREATE TABLE values (_id INTEGER PRIMARY KEY AUTOINCREMENT, name text, caption text, lines integer , photo_url text, type text);

Here is how I'm trying to create db table:

private static final String TABLE_VALUES_CREATE =
    "CREATE TABLE " + DATABASE_TABLE_VALUES +
           " (_id INTEGER PRIMARY KEY AUTOINCREMENT, "
          + ValueTemplate.KEY_NAME + " text, "
          + ValueTemplate.KEY_CAPTION + " text, "
          + ValueTemplate.KEY_LINES + " integer , "
          + ValueTemplate.KEY_PHOTOURL + " text, "
          + ValueTemplate.KEY_TYPE + " text);";

   //ValueTemplate class:
   // VALUE TEMPLATES

      public static final String KEY_CAPTION = "caption";
      public static final String KEY_NAME = "name";
      public static final String KEY_TYPE = "type";
      public static final String KEY_LINES = "lines";
      public static final String KEY_PHOTOURL = "photo_url";

Nermeen · Accepted Answer · 2012-11-12 13:46:19Z

5

I think because (values) is a reserved name, rename your table..

answered Nov 12, 2012 at 13:46

Nermeen

16k5 gold badges62 silver badges73 bronze badges

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

Comments

Romain Guidoux · Accepted Answer · 2012-11-12 13:46:08Z

3

The name of your table (values) is a keyword reserved by SQLite.

See here for the list of keywords: http://www.sqlite.org/lang_keywords.html

answered Nov 12, 2012 at 13:46

Romain Guidoux

2,9715 gold badges31 silver badges50 bronze badges

Comments

waqaslam · Accepted Answer · 2012-11-12 13:56:54Z

2

If you insist on keeping the exact same table name then try [values], otherwise the best would be to rename it to something like tblValues

answered Nov 12, 2012 at 13:56

waqaslam

68.3k17 gold badges172 silver badges180 bronze badges

Collectives™ on Stack Overflow

SQLiteException: near /TABLE_NAME/: syntax error

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related