问题(LogCat中)
源码返回:错误code = 1,味精=没有这样的表...
android.database.sqlite.SQLiteException:没有这样的表:......
code
公共无效的onCreate(SQLiteDatabase DB){
Log.v(SQLAdapter,的onCreate(SQLiteDatabase分贝));
db.execSQL(CREATE TABLE+表名
+(
+ COL1 +TEXT PRIMARY KEY,
+ COL2 +TEXT
+ COL3 +TEXT
+ COL4 +TEXT
+ COL5 +TEXT
+ COL6 +TEXT
+ COL7 +TEXT
+ col8 +TEXT
+));
db.execSQL(CREATE TABLE+ configTable
+(
+ COLNAME +TEXT PRIMARY KEY,
+ COLVALUE +TEXT
+));
ContentValues CV =新ContentValues();
cv.put(COLNAME,更新);
cv.put(COLVALUE, - 1);
db.insert(configTable,COLNAME,CV);
}
结果
正在创建configTable
不被创建的表名
解决方案简单的改变,你实现了使用SQliteDatabase在数据基础类你DATABSE名称
我面临同样的问题,isolved使用同样的伎俩。
ISSUE (LogCat)
sqlite returned: error code = 1, msg = no such table ...
android.database.sqlite.SQLiteException: no such table: ....
CODE
public void onCreate(SQLiteDatabase db) {
Log.v("SQLAdapter","onCreate(SQLiteDatabase db)");
db.execSQL("CREATE TABLE "+tablename
+" ("
+col1+ " TEXT PRIMARY KEY , "
+col2+ " TEXT , "
+col3+ " TEXT , "
+col4+ " TEXT , "
+col5+ " TEXT , "
+col6+ " TEXT , "
+col7+ " TEXT , "
+col8+ " TEXT "
+")");
db.execSQL("CREATE TABLE "+configTable
+" ("
+colName+ " TEXT PRIMARY KEY , "
+colValue+ " TEXT "
+")");
ContentValues cv=new ContentValues();
cv.put(colName, "updated");
cv.put(colValue, "-1");
db.insert(configTable, colName, cv);
}
RESULT
configTable is being created
tablename is not being created
解决方案
simply Change Your Databse name in Data base class which you implemented Using SQliteDatabase
same problem i faced , isolved using same trick.