使用SQLite提供可靠的用户反馈-ProvidingreliableuserfeedbackwithSQLite

Besides exception handling... You should reselect the data from the db that the user did commit by clicking on the save button. That way you know for sure that the user sees the right data.

除了异常处理之外......您应该通过单击“保存”按钮从用户确实提交的数据库中重新选择数据。这样您就可以确定用户看到了正确的数据。

If I understand correctly you are doing a GUI application that modifies information in a SQLite db.

如果我理解正确,你正在做一个修改SQLite数据库中的信息的GUI应用程序。

• Not really, you might get SQLITE_BUSY if you have threads; SQLITE_INTERNAL; etc. Check SQLite documentation. Instead of asking for SQLITE_ERROR you could do something like:

不是真的,如果你有线程,你可能会得到SQLITE_BUSY; SQLITE_INTERNAL;检查SQLite文档。而不是要求SQLITE_ERROR你可以做类似的事情:

SQLITE_OK or SQLITE_DONE depending on what you are doing.

SQLITE_OK或SQLITE_DONE取决于您正在做什么。

if (ret != SQLITE_OK || ret != SQLITE_DONE)
    //then this is an error.

• Don't know in what language are you coding, but I did an abstraction of SQLite in C here. You might find it interesting.

  不知道你用什么语言编写代码,但我在这里用C语言抽象了SQLite。你可能会发现它很有趣。

• Use sqlite3_trace()