Database Creation in android

Question

I am creating a table which works on the simulator but not on the device. I get this error message:

Failure 1 (near "(": syntax error) on 0x2d69a8 when preparing 'CREATE TABLE request(requestidINTEGER PRIMARY KEY,longitudefromDECIMAL(10,5),lattitudefromDECIMAL(10,5),phoneINTEGER)

I am creating the table like this:

 String CREATE_REQUEST_TABLE= "CREATE TABLE " + TABLE_REQUEST + "(" 
                    + KEY_REQUESTID + "INTEGER PRIMARY KEY," 
                    + KEY_LONGITUDEFROM + "DECIMAL(10,5)," 
                    + KEY_LATTITUDEFROM + "DECIMAL(10,5)," 
                    + KEY_TO + "TEXT," 
                    + KEY_DEPARTURETIME + "TIME," 
                    + KEY_ARRIVALTIME + "TIME," 
                    + KEY_DESCRIPTION + "TEXT," 
                    + KEY_PHONE + "INTEGER" + ")"; 
            db.execSQL(CREATE_REQUEST_TABLE);

Yury · Accepted Answer · 2012-05-15 21:06:01Z

2

You do not have spaces in your request. Add space before and after key:

String CREATE_REQUEST_TABLE= "CREATE TABLE " + TABLE_REQUEST + " (" 
                + KEY_REQUESTID + " INTEGER PRIMARY KEY, " 
                + KEY_LONGITUDEFROM + " DECIMAL(10,5), " 
                + KEY_LATTITUDEFROM + " DECIMAL(10,5), " 
                + KEY_TO + " TEXT, " 
                + KEY_DEPARTURETIME + " TIME, " 
                + KEY_ARRIVALTIME + " TIME, " 
                + KEY_DESCRIPTION + " TEXT, " 
                + KEY_PHONE + " INTEGER" + ")";

answered May 15, 2012 at 21:06

Yury

21k8 gold badges61 silver badges87 bronze badges

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

1 Comment

Joe Over a year ago

thank you that was it but i was wondering why on the emulator it was working fine when i tried it on the device it crashes.. but now everything is working

SavasCinar · Accepted Answer · 2012-05-15 21:08:55Z

1

Try with space between your id and "INTEGER PRIMARY KEY,"

Like;

    KEY_REQUESTID + " INTEGER PRIMARY KEY,"

answered May 15, 2012 at 21:08

SavasCinar

6673 gold badges8 silver badges25 bronze badges

Comments

K-ballo · Accepted Answer · 2012-05-15 21:05:19Z

1

Well, as you can see in the error message, KEY_REQUESTID + "INTEGER PRIMARY KEY," turns into requestidINTEGER PRIMARY which is not requestid INTEGER PRIMARY. Basically, there is no space between the column name and the column type which makes them look (to SQLite) as a single token.

answered May 15, 2012 at 21:05

K-ballo

81.6k20 gold badges165 silver badges172 bronze badges

Collectives™ on Stack Overflow

Database Creation in android

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related