getting error : Caused by: android.database.sqlite.SQLiteException: near "TABLENAME" syntax error (code 1) compiling a SELECT query

Question

I'm getting the following error while compiling a SELECT query:

Caused by: android.database.sqlite.SQLiteException: near "group": syntax error (code 1): , while compiling: SELECT group_id, logo FROM group WHERE group_name = 'Empty Group'

The query is created as:

c = database.query(TABLE_GROUP, new String[]{KEY_GROUPID, KEY_LOGO}, KEY_GROUPNAME + " = '" + description + "'", null, null, null, null);

with:

TABLE_GROUP = "group";
KEY_LOGO = "logo";
KEY_GROUPID = "group_id";

and the creation script for the table:

create table group 
(group_id integer primary key autoincrement, 
group_name text not null, 
logo string);

Anyone knows what's wrong?

make sure 'group' is not a keyword. change table's name to something else then check — Shahzeb
– Shahzeb, Commented Oct 4, 2015 at 12:44

Blackbelt · Accepted Answer · 2015-10-04 12:47:35Z

2

group is a SQLITE keyword and, as every reserved words, it can't use it as table/column name. To fix chose another name for your column. You can find a list of the SQLITE reserved keywords here

answered Oct 4, 2015 at 12:47

Blackbelt

158k31 gold badges308 silver badges310 bronze badges

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

1 Comment

Silvio Barbieri Over a year ago

You're completely right. I completely forgot that "group by" can be used in SQL. I needed someone to remember me! Thank you!

Collectives™ on Stack Overflow

getting error : Caused by: android.database.sqlite.SQLiteException: near "TABLENAME" syntax error (code 1) compiling a SELECT query

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related