From: Milan B. <mi...@pa...> - 2007-03-09 15:35:58
|
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 |