Subject Re: [IBO] TIB_Checkbox
Author Helen Borrie
At 05:56 PM 16-09-02 +0200, you wrote:
>For some "boolean" defined table fields, I try to use TIB_Checkboxes.
>
>With a database domain, I defined TBoolean like :
>
>CREATE DOMAIN "TBoolean" AS
>CHAR(6)
>DEFAULT 'NEIN'
>CHECK (VALUE BETWEEN 'JA' AND 'NEIN')

Your SQL for the check constraint is wrong. You should have made it

CHECK (VALUE IN ('JA', 'NEIN'))


>How can I "tell" the TIB_Checkboxes to use these values?

Once you have a valid check constraint, you can set the BOOLEAN item of the
ColumnAttributes for that domain in your IB_Connection, as follows:

1. In the FieldEntryTypes, make sure that fetDomainName is included in the
set; and
2. In the ColumnAttributes, place this entry:

TBoolean=BOOLEAN=JA,NEIN

Helen