Why is my SQL create statement causing my app to crash?

Question

Error message:

android.database.sqlite.SQLiteException: near "transaction": syntax error (code 1): , while compiling: **create table transaction ( _id integer primary key autoincrement, amount real, type varchar(20), date integer)

My app stores monetary transactions composed of an auto-generated ID, the amount spent, and type of payment and the date. My app compiles fine, but when i try run the activity in which the database is sqlite database is created, the app crashes with the above message. As far as im aware my SQL statement is valid, could anybody offer any insight into what could possibly be the cause?

Java Code:

 db.execSQL("create table transaction (" +
        " _id integer primary key autoincrement, amount real, type varchar(20), date integer)");

Thanks

i belive this is duplicated here: http://stackoverflow.com/questions/6900437/android-app-unable-to-start-activity-componentinfo No? — Vetras, Jan 21 '15 at 14:03
I removed that part of the error and it's much clearer now that this is not a duplicate of that :) — Adam S, Jan 21 '15 at 14:04

score 10 · Accepted Answer · answered Jan 21 '15 at 14:03

10

transaction is an SQLite Keyword. Name your table something else (say, sales).

answered Jan 21 '15 at 14:03

Adam S

16,144
6
54
81

Why is my SQL create statement causing my app to crash?

1 Answers1