Android sqliteException near "CREATE": syntax error

Question

I'm developing a database for my app and when I try to add a new user into the database I get this error

android.database.sqlite.SQLiteException: near "CREATE": syntax error while

I've looked at other questions and seen that the spacing and quote positioning is very important. But looking at other working examples mine's seems to be correct?

My class below

    private static final String TABLE_NAME = "FITNESSMATETABLE";
    private static final String DATABASE_NAME = "fitnessmatedatabase";

    private static final String USERID = "_id";
    private static final String NAME = "Name";
    private static final String PASSWORD = "Password";

    //Database Version
    private static final int DATABASE_VERSION = 18;

    //The database strings themselves
private static final String CREATE_TABLE = "CREATE TABLE " + TABLE_NAME
        + " (" + USERID + " INTEGER PRIMARY KEY AUTOINCREMENT, " + NAME
        + " TEXT, " + PASSWORD + " TEXT);";

Looking at the error I believe it's telling me that the quotations around "CREATE" are wrong. Can anyone see anything out of the ordinary?

Thanks in advance

Please post full exception and stacktrace.

laalto
– laalto

2014-05-09 04:33:53 +00:00
Commented May 9, 2014 at 4:33 — laalto
– laalto, Commented May 9, 2014 at 4:33

Pieces · Accepted Answer · 2014-05-09 02:07:26Z

2

Varcars aren't available in sqlite. Trying replacing them with TEXT. Check here for sqlite data types http://www.sqlite.org/datatype3.html

answered May 9, 2014 at 2:07

Pieces

2,3045 gold badges26 silver badges39 bronze badges

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

Comments

Santhi Bharath · Accepted Answer · 2014-05-09 02:33:32Z

-1

The following syntax will work for you

create table FITNESSMATETABLE (_id integer primarykey auto increment,Name text,password text);

answered May 9, 2014 at 2:33

Santhi Bharath

2,9005 gold badges31 silver badges42 bronze badges

4 Comments

IrishCrf Over a year ago

unfortunately I'm still getting the same error with that syntax. I'll keep trying here, Thanks

Santhi Bharath Over a year ago

Change your code , and directly write private static final String CREATE_TABLE="create table FITNESSMATETABLE (_id integer primarykey auto increment,Name text,password text);"

IrishCrf Over a year ago

code private static final String CREATE_TABLE="create table FITNESSMATETABLE (_id integer primarykey auto increment,Name text,Password text);";code still getting the same error

Santhi Bharath Over a year ago

Then, that is not the syntax issue. This will come if DB is not create properly . Please check your DB creation

Collectives™ on Stack Overflow

Android sqliteException near "CREATE": syntax error

2 Answers 2

Comments

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related