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
http://www.upscene.com

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

Database questions? Check the forum:
http://www.databasedevelopmentforum.com