I use
CREATE DOMAIN "BOOL" AS CHAR(1)
DEFAULT 'N'
CHECK (VALUE ='J' OR VALUE='N');

You can use .asInteger

I defined the IB_Query Columnattributes
(Checkbox Boolean, True Text "J" False Text "N")
and then I can use .asBoolean also

Oliver Wurdak

> Hi
> I know there are numerous ways to convert the booleans in paradox to
> interbase, such as a domain (0,1) or (Y,N) or just as in
> integer/smallint field. I would appreciate it if you just posted
> method you use with your database.
> Also, what is the best way to referece these boolean fields. If I
> were to create a domain (0,1) do I still use 'asinteger' in my code ?
>
> Thanks Rod