I am trying to do the following. Check the system tables in a FDB to see
what the current structure is
and then write an update string to change the table/database. The problem I
am having is checking what
is in the tables.
I go to the "RDB$RELATION_FIELDS" and query for table name, Then cycle
through the result getting
each field name. I then check "RDB$FIELDS.RDB$FIELD_NAME" using
"RDB$RELATION_FIELDS.RDB$FIELD_SOURCE"
to get the length and I then realy need the details I would see in the
domain but checking "RDB$TYPES"
does not realy get me anywhere. say I have a field that is numeric 19.6 how
do I get this detail out.

Many thanks
Slim


INTACT Software
2 Mourne View
Dublin Road
Dundalk
Co. Louth
Ireland

W: www.intact.ie
T: +353-42-9331742
F: +353-42-9326357

Confidentiality Note: The information contained in this email and
document(s) attached are for the exclusive use of the addressee
and may contain confidential, privileged and non-disclosable information.
If the recipient of this email is not the addressee, such recipient
is strictly prohibited from reading, photocopying, distribution or
otherwise using this email or its contents in any way.