Hello, I'm using the build mentioned in the subject, 32-bit, on Windows 7 64-bit.
I have the following sequence of created domains in isql: SQL> create domain d_mydomain bigint; SQL> commit; SQL> create domain d_mydomain_1 bigint; SQL> commit; SQL> create domain d_mydomain_2 bigint; SQL> create domain d_mydomain_3 bigint; SQL> commit; SQL> The following query: select f.rdb$field_name, rdb$default_source, rdb$validation_source from rdb$fields f left outer join rdb$field_dimensions fd on f.rdb$field_name = fd.rdb$field_name where (f.rdb$system_flag = 0 or f.rdb$system_flag is null) and f.rdb$field_name not like 'RDB$%' order by f.rdb$field_name, fd.rdb$dimension returns: RDB$FIELD_NAME RDB$DEFAULT_SOURCE RDB$VALIDATION_SOURCE ------------------------------------------------------------------------ D_ACCOMMODATIONCATEGORY DEFAULT 0 CHECK (VALUE BETWEEN 0 AND 5) D_BOOLEAN D_BOOLEAN_FALSE DEFAULT FALSE CHECK (VALUE BETWEEN 0 AND 5) D_BOOLEAN_NULL D_BOOLEAN_TRUE DEFAULT TRUE CHECK (VALUE BETWEEN 0 AND 5) D_ID D_IDREF DEFAULT TRUE CHECK (VALUE BETWEEN 0 AND 5) D_MYDOMAIN D_MYDOMAIN_1 DEFAULT TRUE CHECK (VALUE BETWEEN 0 AND 5) D_MYDOMAIN_2 D_MYDOMAIN_3 DEFAULT TRUE CHECK (VALUE BETWEEN 0 AND 5) Mind default source and validation_source for domains that have been created without a default etc. Thanks, Thomas ------------------------------------------------------------------------------ Meet PCI DSS 3.0 Compliance Requirements with EventLog Analyzer Achieve PCI DSS 3.0 Compliant Status with Out-of-the-box PCI DSS Reports Are you Audit-Ready for PCI DSS 3.0 Compliance? Download White paper Comply to PCI DSS 3.0 Requirement 10 and 11.5 with EventLog Analyzer http://pubads.g.doubleclick.net/gampad/clk?id=154622311&iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
