BooleanDomainFields 8.4.1

Discussion of open issues, suggestions and bugs regarding UniDAC (Universal Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
leonardt.neugebauer
Posts: 32
Joined: Wed 27 May 2020 06:22

BooleanDomainFields 8.4.1

Post by leonardt.neugebauer » Tue 16 Mar 2021 06:29

Hello,
is it intended that BooleanDomainFields is by default False since update 8.4.1 ?

Provider: Interbase
unidac 8.3.2 BooleanDomainFields (default True)
unidac 8.4.1 BooleanDomainFields (default False)

leonardt.neugebauer
Posts: 32
Joined: Wed 27 May 2020 06:22

Re: BooleanDomainFields 8.4.1

Post by leonardt.neugebauer » Tue 16 Mar 2021 08:01

Unfortunately, if you want to override the constructor and set BooleanDomainFields, you cannot.

In the project *** there is an exception of the class EIBCError with the message 'Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, column 113
)' occurred.

Even the SQL doesn't even contain a bracket.

After creating, you can set it and it works.

oleg0k
Devart Team
Posts: 190
Joined: Wed 11 Mar 2020 08:28

Re: BooleanDomainFields 8.4.1

Post by oleg0k » Tue 16 Mar 2021 16:12

Hello,
Yes, the default value of TUniQuery.SpecificOptions.Values['InterBase.BooleanDomainFields'] was changed in UniDAC 8.4.1 to False. We made this change to increase the performance of UniDAC and align its behavior with IBDAC. For information about the property, see https://www.devart.com/unidac/docs/usi ... storedproc
You can revert the behavior by setting the property to True.
We've resolved the "Token unknown" error when BooleanDomainFields=True. The fix will be included in the next release. If you urgently need the fix, please send us your UniDAC license number and your IDE version through the form https://devart.com/company/contactform.html, and we'll send you the nigthly build that includes the fix. Note that since it's a nigthly build, it might contain some issues.

wbr, Oleg
Devart Team

Post Reply