SQLite boolean value always false

Ok, good…
Thanks to your advice I realized that it could not be the program that displayed Y/N but it was the data inside the database.
I tried to put true and false values back instead of Y / N and everything works.
I realized that “SQLPro for SQLite” converted the database to the latest version of SQLite 3.x and transformed, I do not know why, the true and false values in Y / N.
Simply putting back the correct data (true and false) everything is back to work. Thanks to all of you, with one’s own advice, that made me solve the problem. Thank you so much!

You can put values for bool data type as

‘TRUE’ and ‘FALSE’ as string

OR

1 for True and 0 for False as integer