With the following sql, fieldtype: nummeric, lenght: 18, scale: 2 are
not shown. Any idea why?
Thanks Bram

select
r.rdb$relation_name as tablename,
r.rdb$field_name as fieldname,
t.rdb$type_name as typename,
f.rdb$field_length as fieldlength, r.RDB$FIELD_SOURCE AS
DOMAINFIELD
from
rdb$relation_fields r, rdb$types t, rdb$fields f
where
r.rdb$relation_name='MATFAC' and
r.rdb$relation_name not like 'RDB%' and
f.rdb$field_name=r.rdb$field_source and
t.rdb$field_name='RDB$FIELD_TYPE' and
f.rdb$field_type=t.rdb$type
order by
r.rdb$relation_name