Subject | Re: [Bulk] [firebird-support] Re: Detect all currency field in a database |
---|---|
Author | Anderson Farias |
Post date | 2009-09-22T19:38:44Z |
Hi,
|know in the query result than myfield is of type D_Currency.
|For now i use the SQLDA.SQLType and SqlScale to know if it's NUMERIC(15,5)
field or not ...
you could query system tables:
select RDB$FIELD_SOURCE
from RDB$RELATION_FIELDS
where RDB$RELATION_NAME='YOUR_TABLE_NAME'
and RDB$FIELD_NAME='YOUR_FIELD_NAME';
Regards,
Anderson
|know in the query result than myfield is of type D_Currency.
|For now i use the SQLDA.SQLType and SqlScale to know if it's NUMERIC(15,5)
field or not ...
you could query system tables:
select RDB$FIELD_SOURCE
from RDB$RELATION_FIELDS
where RDB$RELATION_NAME='YOUR_TABLE_NAME'
and RDB$FIELD_NAME='YOUR_FIELD_NAME';
Regards,
Anderson