Thanks for that have found the relevant info.
Many thanks
Slim

-----Original Message-----
From: Nando Dessena [mailto:nandod@...]
Sent: 12/11/2003 22:29
To: Firebird-Support (E-mail)
Subject: Re: [firebird-support] Table structure


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@...



To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com



Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/




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.