Slim,

s> I go to the "RDB$RELATION_FIELDS" and query for table name, Then cycle
s> through the result getting
s> each field name. I then check "RDB$FIELDS.RDB$FIELD_NAME" using
s> "RDB$RELATION_FIELDS.RDB$FIELD_SOURCE"
s> to get the length and I then realy need the details I would see in the
s> domain but checking "RDB$TYPES"
s> does not realy get me anywhere. say I have a field that is numeric 19.6 how
s> do I get this detail out.

RDB$FIELD_TYPE, RDB$FIELD_SUBTYPE, RDB$FIELD_LENGTH, RDB$FIELD_SCALE
have the necessary info. Of course you will need to decode them, have a
look at the docs.

Ciao
--
Nando mailto:nandod@...