Thanks Ivan,

But that I know. Sorry, I think I've been a little not direct on
what I want here. Look, I need a table so I can make this "translation".

For example, I know that LONG(4) is the INTEGER in Firebird. But
what is Int64 (8,-4) just to be in one example only?

I would like this table of translation so I can convert the types I
get with the SQL String to put it in my code.

Thanks

Ivan Prenosil wrote:

>> But the problem is that the RDB$TYPE_NAME and RDB$FIELD_LENGTH is
>>quite different from what is shown in the Firebird GUI I use. There, it
>>shows varchar, integer, etc and when I run the SQL Script it shows
>>varying, long, text, int64, etc.
>>
>> So, does anyone knows how to convert these types shown when i run
>>the SQL Script to the types shown in the Firebird GUI?
>>
>>
>
>Yes, use CASE expression.
>
>SELECT
> CASE RDB$FIELD_TYPE WHEN 8 THEN 'INTEGER' WHEN 37 THEN 'VARCHAR' ... END
>
>Ivan
>
>
>
>
>Yahoo! Groups Links
>
>
>
>
>
>
>
>
>
>