2005/11/4, Helen Borrie <helebor@...>:

> At 09:41 AM 4/11/2005 -0300, you wrote:
> >Hi Helen,
> >
> >CREATE DOMAIN BOOLEAN AS
> >CHAR(1) CHARACTER SET WIN1252
> >DEFAULT 'N'
> >CHECK (value in ('N', 'S'))
> >COLLATE WIN1252
> >
> >I do the tests with two fields. One using the domain above, and other
> >field without domain. The result was the same: both 'N' (false) and
> >'S' (true) are handle as false!!! Tried with 'T' and 'F', and didn't
> >works too.
> >
> >I don't know what is happen.
>
> Do you have these properties set in your DBCheckBox?
>
> DBCheckBox1.ValueChecked := 'S';
> DBCheckBox1.ValueChecked := 'N';
>
> I don't think TDBCheckBox is specifically for Boolean pairs like
> TIB_CheckBox is...

Just changed that properties and still didn't work. I used a lot of
TDBCheckbox with Paradox, and it always works fine with boolean
fields. As I concern it is specially made for this.

How about use a calculated field as I describe in my last message.
What do u think?

[]
Andrei