Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- New Code for create table:
- static final String CREATE_DB_TABLE = " CREATE TABLE " + TABLE_NAME
- + " (id INTEGER PRIMARY KEY AUTOINCREMENT, "
- + " name TEXT NOT NULL, "
- + " grade INTEGER NOT NULL, "
- + " department INTEGER NOT NULL);";
- Error I'm getting:
- E/SQLiteLog: (1) table Employees has no column named department
- E/SQLiteDatabase: Error inserting name=admin department=5 grade=4
- android.database.sqlite.SQLiteException: table Employees has no column named department (code 1 SQLITE_ERROR[1]): , while compiling: INSERT INTO Employees(name,department,grade) VALUES (?,?,?)
- at android.database.sqlite.SQLiteConnection.nativePrepareStatement(Native Method)
- at android.database.sqlite.SQLiteConnection.acquirePreparedStatement(SQLiteConnection.java:1260)
- at android.database.sqlite.SQLiteConnection.prepare(SQLiteConnection.java:703)
- at android.database.sqlite.SQLiteSession.prepare(SQLiteSession.java:588)
- at android.database.sqlite.SQLiteProgram.<init>(SQLiteProgram.java:59)
- at android.database.sqlite.SQLiteStatement.<init>(SQLiteStatement.java:31)
- at android.database.sqlite.SQLiteDatabase.insertWithOnConflict(SQLiteDatabase.java:2019)
- at android.database.sqlite.SQLiteDatabase.insert(SQLiteDatabase.java:1890)
- at com.phehossof.launcher.ProviderContent.insert(ProviderContent.java:77)
- at android.content.ContentProvider$Transport.insert(ContentProvider.java:266)
- at android.content.ContentResolver.insert(ContentResolver.java:1594)
- at com.phehossof.launcher.ActivityHome$1.onResponse(ActivityHome.java:64)
- at retrofit2.DefaultCallAdapterFactory$ExecutorCallbackCall$1$1.run(DefaultCallAdapterFactory.java:83)
- at android.os.Handler.handleCallback(Handler.java:873)
- at android.os.Handler.dispatchMessage(Handler.java:99)
- at android.os.Looper.loop(Looper.java:216)
- at android.app.ActivityThread.main(ActivityThread.java:7266)
- at java.lang.reflect.Method.invoke(Native Method)
- at com.android.internal.os.RuntimeInit$MethodAndArgsCaller.run(RuntimeInit.java:494)
- at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:975)
Advertisement
Add Comment
Please, Sign In to add comment