red_october_canada wrote:

> 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'

Thanks.


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
off-topic here.


--
Milan Babuskov
http://www.guacosoft.com
http://www.flamerobin.org