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: 7
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: 1822
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.

Niels
Posts: 7
Joined: Fri 20 Apr 2012 05:24

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

Post by Niels » Thu 09 Dec 2021 00:37

Is there any update on this issue? or do you know when and in which release it can be fixed?
I just need to know if I can incorporate a new fixed version in our next release before Christmas...
Thank you

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

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

Post by MaximG » Wed 22 Dec 2021 09:45

We continue working on this issue. We hope to get results in the shortest time.

Post Reply