Devart Forums

Hello,
I am trying to use BooleanDomainFields but I couldn't make it work. I have defined the following domain

create domain D_BOOLEAN int check (value is null or value in (1, 0);

and specified the coBooleanDomainFields option (this project uses Delphi 7) but I keep getting integer fields in the datasets. I have also tried with a domain called "BOOLEAN" but nothing changed. What am I doing wrong?

P.S. I would rather use smallint as a data type. Is it supposed to work?

P.P.S. I have just bought the driver and I stumbled upon two showstoppers in a row. It's not fun.

Thanks
--
Nando

BooleanDomainFields should work for this domain. It works for domains based on SMALLINT, INTEGER, and BIGINT.

We could not reproduce the problem. Please send to dbxida*devart*com a complete small sample that demonstrates the problem, including the script for creating database objects.

On my way to creating the sample. Hopefully in the process I'll find what I am doing wrong.

P.S. I am using a joined query, Delphi 7 and version 2.40.0.16 of the driver against Firebird 2.1. Should it make any difference?

Thanks
--
Nando

The driver can get the domain name for a field if the server returns table name and original field name for that field.

Such information is not returned for expressions, and maybe is not returned for the field in your query.

My fault, the test case was using the standard IB driver instead of DevArt. Working fine now, thanks.

hello,

I am having the same problem, please help me.
I followup all what was said in the manual regarding the booleanDomainFields, still it didn't work.

please help,,...

thanks....

Please give a more detailed description of the problem.

the Devart team solved the problem through their reply to my email.
thanks once again.

best regards,