SQLite and Boolean

[AlbertoD]

Maybe so but not clear when Enric said:

@Enric_Herrera

I also have used this code for years, but now…

and

@Enric_Herrera

Should I change all code that has been working till now?

BTW it looks like the bug was fixed before, I found this thread:

DatabaseColumn.BooleanValue does not return true for 1

I have been converting a web app to API2.0 and found when I use a rowset and databaserow instead of a recordset, I get False instead of True when the column value is 1. dim rs As rowset = Session.db.SelectSQL(“SELECT * FROM Test”) if rs<>nil Then for each row as DatabaseRow in rs var a As string = row.Column(“Item”).StringValue var b As Boolean = row.Column(“Item”).BooleanValue CheckBox1.Value = row.Column(“Item”).booleanValue next end if If the ‘Item’ field = 1, a will be 1 and b will…

and this fixed bug:
#61636 - boolean returns always false in postgresql (closed)