Perhaps it has been a long day for me but after staring at this for 5
minutes or so I cannot figure out what is going on here...

Could you send me a code snippet as well as the DDL backing things up?

Thanks,
Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com

----- Original Message -----
From: "Brian Dunstan" <bdunstan@...>
To: <IBObjects@egroups.com>
Sent: Thursday, November 16, 2000 7:50 PM
Subject: [IBO] ColumnAttributes Bug - Jason


> I am using IBO version 3.6Bc and have detected the following bug.
>
> IBODatabase.ColumnAttributes are
> CHRONIC_CONDITION_SUBTYPE=BOOLEAN=Y,N; <- This is Char(1) column name
> TRUE_FALSE=BOOLEAN=T,F; <- This is Domain name Char(1)
>
> IBODatabase.FieldEntryTypes := [fetDomainName]
>
> With CHRONIC_CONDITION_SUBTYPE column = Y
> IBOQuery.FieldByName('CHRONIC_CONDITION_SUBTYPE').AsString = ''
> IBOQuery.FieldByName('CHRONIC_CONDITION_SUBTYPE').AsBoolean = False
>
> IB_Query.FieldByName('CHRONIC_CONDITION_SUBTYPE').AsString = 'Y'
> IB_Query.FieldByName('CHRONIC_CONDITION_SUBTYPE').AsBoolean = True
>
> Clearly, both types of dataset should give the same results.
>
> If IBODatabase.FieldEntryTypes := [] then fields not based on domain names
> work as expected, but of course the domain based fields are no longer
> recognized as Boolean.
>
> So now I am in the awkward position of having completed the tedious task
of
> changing some 600 source files to use Boolean definitions....
>
> Brian
>
>
>
>