Hello and welcome,

> 1) How can I retrieve the field names list from a table. I mean,
> using an access driver i can easily use "SELECT TOP 1 * FROM table"
> and then , with ADO, just loop into the recordset fields object to
> have the field names. How could I do with ADO And Firebird, since
> either the Shema GetColumns seems to work?

Use the following syntax

SELECT FIRST 1 * FROM table
or a
SELECT * FROM table where <condition_returning_0_rows>

if you want to loop thru fields objects.

You could also query the system tables

SELECT RDB$FIELD_NAME, ... FROM RDB$RELATION_FIELDS
WHERE RDB$RELATION_NAME = '<your case-sensitive table name>'

and loop thru records.

> 2) Using the free FireBird/Interbase ODBC Driver, if i retreive a
> DECIMAL (or NUMERIC) field (size 18, base 4) I always get back a 0
> value, no matter what is the actual value. Changing the driver to the
> Easysoft one, make things work. Any suggestion?

Can't help here. You might want to ask on the FB ODBC driver list.

Regards.

--
Jerome