Subject | Re: [IBO] TIB_Checkbox |
---|---|
Author | Helen Borrie |
Post date | 2002-09-16T16:18:16Z |
At 05:56 PM 16-09-02 +0200, you wrote:
CHECK (VALUE IN ('JA', 'NEIN'))
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
>For some "boolean" defined table fields, I try to use TIB_Checkboxes.Your SQL for the check constraint is wrong. You should have made it
>
>With a database domain, I defined TBoolean like :
>
>CREATE DOMAIN "TBoolean" AS
>CHAR(6)
>DEFAULT 'NEIN'
>CHECK (VALUE BETWEEN 'JA' AND 'NEIN')
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