From: Milan Babuskov <milanb@pa...> - 2007-03-09 15:35:58
> IS_ACV DOM_BOOLEAN DEFAULT 'Yes'
> I have declared many fields of type DOM_BOOLEAN through-out my DB and
> the problem appears to be random.
I see. I tried to reproduce it and failed.
> Some end up with the the extra 'T'
> and some don't.
Does ISQL output the DDL properly? (Using "show table" command")
> IS_ACV DOM_BOOLEAN /* Uss the domain's default of 'No'*/
> IS_ACV DOM_BOOLEAN DEFAULT 'Yes' /* Override with a 'Yes' */
> In either case, the extra T may or may not show up.
Could you show us the results of this query:
select * from RDB$FIELDS where rdb$field_name = 'DOM_BOOLEAN';
and also for this (replace TABLE_NAME with real name of table):
select * from RDB$RELATION_FIELDS where
rdb$relation_name = 'TABLE_NAME' and rdb$field_name = 'IS_ACV'
P.S. If ISQL shows DDL properly, perhaps we should move this discussion
to flamerobin-devel list or private e-mails as it would be somewhat