tlmarker1968

Error 3.0

Oct 26th, 2019
203
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.22 KB | None | 0 0
  1. New Code for create table:
  2.  
  3. static final String CREATE_DB_TABLE = " CREATE TABLE " + TABLE_NAME
  4. + " (id INTEGER PRIMARY KEY AUTOINCREMENT, "
  5. + " name TEXT NOT NULL, "
  6. + " grade INTEGER NOT NULL, "
  7. + " department INTEGER NOT NULL);";
  8.  
  9. Error I'm getting:
  10.  
  11. E/SQLiteLog: (1) table Employees has no column named department
  12. E/SQLiteDatabase: Error inserting name=admin department=5 grade=4
  13. 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 (?,?,?)
  14. at android.database.sqlite.SQLiteConnection.nativePrepareStatement(Native Method)
  15. at android.database.sqlite.SQLiteConnection.acquirePreparedStatement(SQLiteConnection.java:1260)
  16. at android.database.sqlite.SQLiteConnection.prepare(SQLiteConnection.java:703)
  17. at android.database.sqlite.SQLiteSession.prepare(SQLiteSession.java:588)
  18. at android.database.sqlite.SQLiteProgram.<init>(SQLiteProgram.java:59)
  19. at android.database.sqlite.SQLiteStatement.<init>(SQLiteStatement.java:31)
  20. at android.database.sqlite.SQLiteDatabase.insertWithOnConflict(SQLiteDatabase.java:2019)
  21. at android.database.sqlite.SQLiteDatabase.insert(SQLiteDatabase.java:1890)
  22. at com.phehossof.launcher.ProviderContent.insert(ProviderContent.java:77)
  23. at android.content.ContentProvider$Transport.insert(ContentProvider.java:266)
  24. at android.content.ContentResolver.insert(ContentResolver.java:1594)
  25. at com.phehossof.launcher.ActivityHome$1.onResponse(ActivityHome.java:64)
  26. at retrofit2.DefaultCallAdapterFactory$ExecutorCallbackCall$1$1.run(DefaultCallAdapterFactory.java:83)
  27. at android.os.Handler.handleCallback(Handler.java:873)
  28. at android.os.Handler.dispatchMessage(Handler.java:99)
  29. at android.os.Looper.loop(Looper.java:216)
  30. at android.app.ActivityThread.main(ActivityThread.java:7266)
  31. at java.lang.reflect.Method.invoke(Native Method)
  32. at com.android.internal.os.RuntimeInit$MethodAndArgsCaller.run(RuntimeInit.java:494)
  33. at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:975)
Advertisement
Add Comment
Please, Sign In to add comment