SQLiteDatabase报错。。。

Question

10-14 09:49:02.770: ERROR/SQLiteOpenHelper(7293): android.database.sqlite.SQLiteException: near "Order": syntax error: CREATE TABLE IF NOT EXISTS ListMms (_id INTEGER PRIMARY KEY,Number VARCHAR,State VARCHAR,Time VARCHAR,Calendar VARCHAR,Order INTEGER,Mms_Content VARCHAR)
看了半天没发现什么错误，请大侠指点一二

Answer 1

db.execSQL("CREATE TABLE IF NOT EXISTS "
+TB_NAME+" ("
+ID+" INTEGER PRIMARY KEY,"
+ORDER+" INTEGER,"
+NUMBER+" VARCHAR,"
+STATE+" VARCHAR,"
+TIME+" VARCHAR,"
+CALENDAR+" VARCHAR,"
+MMS_CONTENT+" VARCHAR)");
}

Answer 2

db.execSQL("CREATE TABLE IF NOT EXISTS "
+TB_NAME+" ("
+ID+" INTEGER PRIMARY KEY,"
+ORDER+" INTEGER,"
+NUMBER+" VARCHAR,"
+STATE+" VARCHAR,"
+TIME+" VARCHAR,"
+CALENDAR+" VARCHAR,"
+MMS_CONTENT+" VARCHAR)");
}

Answer 3

你SQL 语法错了....先把sql在sqlite下调试成功吧。

Answer 4

oder后面少个by～  order by 字段 asc/desc

Answer 5

把order改下名字就OK了～ order是关键字

Answer 6

#8 应该是对的，修改成 _order 估计就可以了

Answer 7

8楼正解，我刚才也在怀疑这个问题，结果试一下，竟然没有报错，这个Order指的是啥东东，
我写变量怎么用到这个词了，真是误打误撞竟然中了，结贴。