android.database.sqlite.SQLiteException: near "Group": syntax error (code 1):

Question

Error

Caused by: android.database.sqlite.SQLiteException: near "Group": syntax error (code 1): , while compiling: create table Group(_id integer primary key autoincrement, GroupName TEXT , MemberName TEXT , TotalExpense TEXT );

Code:-

public static final String CREATE_GROUP_TABLE = "create table " + ROOM_GROUP_TABLE +
            "(" + GROUP_ID + " integer primary key autoincrement, "
            + ROOM_COLUMN_GROUP_NAME + " TEXT , "
            + ROOM_COLUMN_MEMBER_NAME + " TEXT , "
            + ROOM_COLUMN_TOTAL_EXPENSE + " TEXT );";

isma3l · Accepted Answer · 2015-07-11 22:27:44Z

9

Your table name can't be Group, Group is a keyword.

List of sqlite keywords: https://www.sqlite.org/lang_keywords.html

answered Jul 11, 2015 at 22:27

isma3l

3,8431 gold badge25 silver badges30 bronze badges

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

Collectives™ on Stack Overflow

android.database.sqlite.SQLiteException: near "Group": syntax error (code 1):

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related