Error adding multiple rows to sqlite database on android

Question

An error occurs when I try to add mulitple rows to the sqlite database. With a single row theres no problem. Additionally the app crashes due to this on a samsung galaxy s2, but not on a nexus.

Heres the code for creating the table:

 private static final String DATABASE_CREATE = "create table "
        + TABLE_AWARDS + "(" + COLUMN_ID
        + " integer primary key autoincrement, " + COLUMN_TITLE
        + " text not null, " + COLUMN_DESCRIPTION + " text not null, "
        + COLUMN_TYPE + " integer not null, " + COLUMN_ACHIEVED
        + " integer not null " + ");";

And the code which inserts the rows into the table:

 private static final String DATABASE_INSERT = "INSERT into  awards (title, description, type, achieved) VALUES "
        + "('Speed maximum', 'Stay', 1 , 0),"
        + "('Speed maximum', 'under 130 km/h', 2 , 0);";

According to the answer of the stackoverflow question you've given me the syntax should be:

private static final String DATABASE_INSERT = "INSERT into  'awards' "+
        "SELECT 'Speed maximum' AS 'title', 'under 150 km/h' AS 'description', 1 AS 'type', 0 AS 'achieved'"
            +" UNION SELECT 'Speed maximum', 'under 130 km/h', 2 , 0"
            +" UNION SELECT 'Speed maximum', 'under 100 km/h', 3 , 0";

But this doesn't work either.

Please check the answer I've tagged. You should find your answer there. — Vinay S Shenoy, Jan 09 '13 at 10:21
I've added the quotes. This doesn't work either. Have I forgotten more quotes? — Chris, Jan 09 '13 at 11:40
Sorry, it's not the quotes.. You need to add a before each "UNION" statement.. — Vinay S Shenoy, Jan 09 '13 at 11:40
Did you remove the quotes around the table name? I had added those by mistake... — Vinay S Shenoy, Jan 09 '13 at 11:45
I've tried it with and without quotes around the table name. Both attempts didn't work. — Chris, Jan 09 '13 at 11:48
let us [continue this discussion in chat](http://chat.stackoverflow.com/rooms/22449/discussion-between-vinay-s-shenoy-and-chris) — Vinay S Shenoy, Jan 09 '13 at 11:54

score 0 · Answer 1 · answered Jan 09 '13 at 12:17

0

In eclipse go to debug mode put a break point after your query and at run-time see the value of strings like DATABASE_INSERT , post it here or you can see the error there itself.

answered Jan 09 '13 at 12:17

android2013

415
2
5

score 0 · Answer 2 · answered Jan 09 '13 at 12:24

0

Please try change the names of columns.
To insert best solution is using insertOrThrow method (read in internet).
Please give me your full code of class extensing SQLiteOpenHelper.
Give logcat log please.

answered Jan 09 '13 at 12:24

TN888

7,235
9
42
82

Error adding multiple rows to sqlite database on android

2 Answers2