Can not save Boolean (Delphi 11, EntityDAC 3.0.2, PostgreSQL 12.8)
Posted: Fri 29 Oct 2021 05:07
Hi I just updated to EntityDAC 3.0.2 in Delphi 11 (Alexandria) and tried to read a table from PostgreSQL 12.8.
It works nicely to a read and access the data. But when I tried to save the changes in any field I get an error message related to an other field of type Boolean I haven't touched!
The error message is: "column 'validate_user' is of type boolean but expression is of type integer!
I took that boolean field out of my model and tried again, now I get the same error message but for an other boolean field!
Might it be possible that EntityDAC tries to convert the boolean value into 0 or 1, as needed with other databases, and then can't save it into the Boolean field of PostgreSQL?
It works nicely to a read and access the data. But when I tried to save the changes in any field I get an error message related to an other field of type Boolean I haven't touched!
The error message is: "column 'validate_user' is of type boolean but expression is of type integer!
I took that boolean field out of my model and tried again, now I get the same error message but for an other boolean field!
Might it be possible that EntityDAC tries to convert the boolean value into 0 or 1, as needed with other databases, and then can't save it into the Boolean field of PostgreSQL?