更新表中的确定字段

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.