Couldn't make BooleanDomainFields work

Couldn't make BooleanDomainFields work

Postby 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
nandod
 
Posts: 15
Joined: Mon 29 May 2006 09:03

Postby 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.
Plash
Devart Team
 
Posts: 2844
Joined: Wed 10 May 2006 07:09

Postby 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
nandod
 
Posts: 15
Joined: Mon 29 May 2006 09:03

Postby 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.
Plash
Devart Team
 
Posts: 2844
Joined: Wed 10 May 2006 07:09

Postby 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.
nandod
 
Posts: 15
Joined: Mon 29 May 2006 09:03

Postby 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....
najmaljazira
 
Posts: 2
Joined: Tue 16 Feb 2010 12:41

Postby Dimon » Tue 16 Feb 2010 15:30

Please give a more detailed description of the problem.
Dimon
Devart Team
 
Posts: 2885
Joined: Mon 05 Mar 2007 16:32

Postby najmaljazira » Wed 17 Feb 2010 07:11

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

best regards,
najmaljazira
 
Posts: 2
Joined: Tue 16 Feb 2010 12:41


Return to dbExpress driver for InterBase & Firebird