我想修改一個確定 id 的字段,在我的例子中該字段是 notify_datetime。但是當我運行應用程序并嘗試這樣做時,應用程序崩潰并出現此錯誤。錯誤:E/AndroidRuntime: FATAL EXCEPTION: main Process: com.example.msnma.movienotifier, PID: 4047 android.database.sqlite.SQLiteException: no such column: notify_datetime (Sqlite code 1): , while compiling: UPDATE MovieTypeTable SET notify_datetime=? WHERE notify_datetime = ?, (OS error - 2:No such file or directory) at android.database.sqlite.SQLiteConnection.nativePrepareStatement(Native Method) at android.database.sqlite.SQLiteConnection.acquirePreparedStatement(SQLiteConnection.java:910) at android.database.sqlite.SQLiteConnection.prepare(SQLiteConnection.java:521) at android.database.sqlite.SQLiteSession.prepare(SQLiteSession.java:603) at android.database.sqlite.SQLiteProgram.<init>(SQLiteProgram.java:63) at android.database.sqlite.SQLiteStatement.<init>(SQLiteStatement.java:31) at android.database.sqlite.SQLiteDatabase.updateWithOnConflict(SQLiteDatabase.java:1856) at android.database.sqlite.SQLiteDatabase.update(SQLiteDatabase.java:1799) at com.example.msnma.movienotifier.database.MovieDatabase.updateNotifyDate(MovieDatabase.java:299) at com.example.msnma.movienotifier.adapter.MoviesAdapter$9.onClick(MoviesAdapter.java:445)該方法稱為updateNotifyDate并且應該修改notify_datetime。在 MoviesAdapter.java 中,只有一塊調用 updateNotifyDate:MovieDatabase md = new MovieDatabase(context);
Log.i("IDMOVIE","ID:"+movies.get(position).getId());
md.updateNotifyDate(movies.get(position).getId(),datatime);
}
1 回答

楊__羊羊
TA貢獻1943條經驗 獲得超7個贊
您正在嘗試更新,MovieTypeTable
但您的圖像表明notify_datetime
已在,MovieTable
因此它正在拋出SQLiteException: no such column
.
添加回答
舉報
0/150
提交
取消