我有一个下表脚本:
"CREATE TABLE " + TABLE_XXX + "("
+ XXX_ID + " INTEGER PRIMARY KEY,"
+ XXX_ITEM_NO + "TEXT,"
+ XXX_DETAILS +"TEXT,"
+ XXX_EXP_DATE + "TEXT,"
+ XXX_IS_OK +"INTEGER, "
+ XXX_CODE + "TEXT"
+ ")";
但是,当我要插入出现错误的数据时,TABLE_XXX没有名为XXX_IS_OK的列。
如何克服它。谢谢!
您需要在代码上留一些空格。在引号之前。
"CREATE TABLE " + TABLE_XXX + "("
+ XXX_ID + " INTEGER PRIMARY KEY, "
+ XXX_ITEM_NO + " TEXT, "
+ XXX_DETAILS +" TEXT, "
+ XXX_EXP_DATE + " TEXT, "
+ XXX_IS_OK + " INTEGER, "
+ XXX_CODE + " TEXT "
+ ")";
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句