not able to update rows
not able to update rows when using select statement and != operator.
Getting this message :
[19:05:16] Cannot edit this cell. Details: The query execution mechanism had problems with extracting ROWID's properly. This might be a bug in the application. You may want to report this.
You are reporting a problem and error message from an application which is not created by SQLite's authors and cannot be supported here. Your report should be directed to whoever is responsible for "the application".
Larry is correct about this being clearly using the interface application of some other vendor, perhaps saying which application might help. I know it's not SQLiteSpeed nor DB Browser for SQLite since I know their error codes, in fact that error seems like it is reported by a wrapper of sorts being used by whatever application you are using.
Either way, the reason I reply is that if only you would post the actual SQL SELECT statement (using the claimed != operator), then there is a probability we could already tell you what is wrong, regardless of how the App or Wrapper deals with it.
The Schema would be useful too. Is that perhaps happening on a WITHOUT ROWID table?