android.database.sqlite.SQLiteException:没有这样的表database、android、SQLiteException、sqlite

2023-09-04 07:55:17 作者:突然好想你

问题(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)

怎样查看 android sqlite数据库

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.