Syntax error on an SQLite query

Question

I'm facing this problem

08-23 14:54:25.370: ERROR/AndroidRuntime(16728): Caused by: android.database.sqlite.SQLiteException: near "table": syntax error: , while compiling: SELECT DISTINCT latitude, longitude FROM table

when the compiler tries to execute this query:

String[] result_columns = new String[] {COL_LATI, COL_LONGI};
       Cursor cur = db.query(true, TABLE_COORD, result_columns,null, null, null, null, null, null);

What can be the source of the problem? I'm not seeing any syntax error on that query. No? Thanks for helping.

Is your table called table? That could very likely be confusing SQLite. — Rafe Kettler
– Rafe Kettler, Commented Aug 23, 2011 at 15:09

androniennn · Accepted Answer · 2011-08-23 15:39:36Z

2

The syntax error comes from the fact the reserved keyword table is used after the from clause of the SQL query. But in the comments you said that the table is called "coord", not "table".

Check your static final String TABLE_COORD, I think it is erroneously set to "table" instead of being set to "coord".

edited Aug 23, 2011 at 15:39

androniennn

3,13711 gold badges53 silver badges107 bronze badges

answered Aug 23, 2011 at 15:17

Shlublu

11.1k4 gold badges53 silver badges70 bronze badges

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

1 Comment

androniennn Over a year ago

AAAAA how i did not noticed this error? And when did i change it ! Sometimes we're making some weird things. Thank you for helping.

Collectives™ on Stack Overflow

Syntax error on an SQLite query

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related