Subject Re: [firebird-support] Re: Detect all currency field in a database
Author Martijn Tonies
Hello Stephane,

> ok, but in this way how to know in a select result that a field is
> D_Currency ? i mean from the API

You don't know that, it's just a naming convention.

> the purpose is when i do
> select
> myfield
> from
> mytable
> 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 ...

That's the only way.

With regards,

Martijn Tonies
Upscene Productions

Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!

Database questions? Check the forum: