Having an error with creating a sqlite table in Android

Question

I'm having a problem with creating a table:

Error:

08-31 02:31:21.559    4121-4121/? E/SQLiteLog﹕ (1) near "limit": syntax error
08-31 02:31:21.689    4121-4121/? E/AndroidRuntime﹕ FATAL EXCEPTION: main
    java.lang.RuntimeException: Unable to start receiver com.mbb.common.SmsReceiver: android.database.sqlite.SQLiteException:
near "limit": syntax error (code 1): , while compiling: CREATE TABLE
feedback(type, speed, expaierdate, date , limit );

MY Code:

 db.execSQL("CREATE TABLE feedback(type , speed , expaierdate , date , limit);");

CL. · Accepted Answer · 2014-08-31 06:49:27Z

3

LIMIT is a keyword.

You can either quote it:

db.execSQL("CREATE TABLE feedback(type, speed, expaierdate, date, \"limit\");");

(in which case you have to quote it every time you use it), or use another name:

db.execSQL("CREATE TABLE feedback(type, speed, expiredate, date, some_limit);");

answered Aug 31, 2014 at 6:49

CL.

182k18 gold badges241 silver badges282 bronze badges

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

1 Comment

An SO User Over a year ago

+1 and a quick question, what is the data type of all these columns if you dont specify any? :)

Collectives™ on Stack Overflow

Having an error with creating a sqlite table in Android

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