Jason,

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

I just created a new table and domain definitions to run with my test
application to send to you AND IT WORKED OK, so now I am really confused.
I'll go back an take another look at the real tables, maybe there is
something funny there.

Sorry to spin your wheels Jason. I'll get back to you as soon as I have
figured out what is going on.

Thanks,

Brian

> 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
> >
> >
> >
> >
>
>
> -------------------------- eGroups Sponsor
> -------------------------~-~>
> eGroups eLerts
> It's Easy. It's Fun. Best of All, it's Free!
> http://click.egroups.com/1/9698/3/_/685810/_/974431610/
> --------------------------------------------------------------
> -------_->
>
>
>