Subject | A couple of questions |
---|---|
Author | chemicalreaction |
Post date | 2003-11-22T16:10:48Z |
Hi there, I am really new at Firebird. Here are my questions:
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?
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?
Thanks and regards.
DT
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?
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?
Thanks and regards.
DT