我有一个下表脚本:
"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 "
+ ")";
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)