Couldn't make BooleanDomainFields work

nandod · Post by **nandod** » Tue 14 Jul 2009 15:12

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

Plash · Post by **Plash** » Wed 15 Jul 2009 08:41

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.

nandod · Post by **nandod** » Wed 15 Jul 2009 08:50

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

Plash · Post by **Plash** » Thu 16 Jul 2009 11:10

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.

nandod · Post by **nandod** » Thu 16 Jul 2009 11:22

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

najmaljazira · Post by **najmaljazira** » Tue 16 Feb 2010 12:44

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

Dimon · Post by **Dimon** » Tue 16 Feb 2010 15:30

Please give a more detailed description of the problem.

najmaljazira · Post by **najmaljazira** » Wed 17 Feb 2010 07:11

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

best regards,