Can not save Boolean (Delphi 11, EntityDAC 3.0.2, PostgreSQL 12.8)

Discussion of open issues, suggestions and bugs regarding EntityDAC
Post Reply
Niels
Posts: 5
Joined: Fri 20 Apr 2012 05:24

Can not save Boolean (Delphi 11, EntityDAC 3.0.2, PostgreSQL 12.8)

Post by Niels » 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?

MaximG
Devart Team
Posts: 1748
Joined: Mon 06 Jul 2015 11:34

Re: Can not save Boolean (Delphi 11, EntityDAC 3.0.2, PostgreSQL 12.8)

Post by MaximG » Tue 02 Nov 2021 16:17

Thank you for the information. We have reproduced the issue and will investigate its origin. We will inform you about the results shortly.

Post Reply