Hi!
Just a note of something achieved for a change, FYI information only.
Running SQLite3.
I needed to change the value of the boolean field “Online” for every record. i.e. a global change. As set the field is either ‘True’ or ‘False’.
Using this SQL in a Kexi query:
UPDATE fables_copy.db
SET online = false;
it cannot be done as the ‘Check Query ‘ function will return an error.
Working in ‘DB Browser’ running this same SQL saw all records successfully changed; but to ‘0’. Kexi would not open this file (I have not tried to repeat this).
HOWEVER: Opening fables_copy.db with sqlite3 at the command line
$ sqlite3 fables_copy.db
Then at the sqlite prompt:
sqlite> UPDATE fables_copy.db SET online = false;
Kexi then opened this; problem solved.
Ian