Subject Re: [IB-Architect] Re: IB 6.1 Whish: boolean field
Author Ross Davis
you could use this instead - it does work with checkboxes
create domain boolean as char(1) default 'F' check (value in ('T','F')) not
null;

You have to set valuechecked and valueunchecked on the check box to T or F,
but it works.


----- Original Message -----
From: John Huntjens <ib-architect@...>
Newsgroups: mers.interbase.ib-architect
To: <ib-architect@...>
Sent: Thursday, August 03, 2000 6:57 AM
Subject: [IB-Architect] Re: IB 6.1 Whish: boolean field


> >> I wonder how the community feels abou implementing a boolean field type
> into
> >> interbase ?
> >>
> >> At this moment I use a domain, but i would like a real boolean type
> better.
> >
> >What's wrong with the domain?
> >
> >create domain boolean as smallint default 0 not null check(value in
> >(0,1))
> >
> >or
> >
> >create domain boolean as char(1) default 'F' not null check(value in
> >('F','T'))
>
>
> I know, but on the delphi side you cannot use a TBooleanField, but get a
> TSmallIntergerField, and thats needs some coding to work. (You cannot use
a
> TDBCheckbox for example)
>
> Also, I find some strange behaviour in the default, I have to duck in it
> deeper te remember what it was.
>
> John
>
>
>
>
>
> _______________________________________________
> Ib-architect mailing list
> Ib-architect@...
> http://mers.com/mailman/listinfo/ib-architect
>
>
>
> To unsubscribe from this group, send an email to:
> IB-Architect-unsubscribe@onelist.com
>
>
>