更新表中的确定字段

Question

我想修改一个确定 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);                         }

Answer 1

您正在尝试更新，MovieTypeTable但您的图像表明notify_datetime已在，MovieTable因此它正在抛出SQLiteException: no such column.