Hi,
Welcome to Firebird :)
I access Firebird using ADO. There are a number of OLE/DB Providers
available for this purpose, some free or very cheap, see www.ibphoenix.com
and check out Third Party Downloads. I use IBProvider and it works very
well.

Once using ADO you can easilty populate a dataset using OpenSchema

FormMain.ADOConnection1.OpenSchema(siColumns, VarArrayOf([Unassigned,
Unassigned, 'MyTable', Unassigned]), EmptyParam, ADODataSet1)
This will populate a dataset with the required info. COLUMN_NAME holds the
FieldName, DATA_TYPE holds the data type etc. Most metadata information can
be obtained using openschema such as indexes, constrataints, primary keys
etc.

Can't help with the ODBC question.


Regards
Peter Gore


_____

From: chemicalreaction [mailto:chemicalreaction@...]
Sent: 22 November 2003 16:11
To: firebird-support@yahoogroups.com
Subject: [firebird-support] A couple of questions


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



Yahoo! Groups Sponsor

ADVERTISEMENT

<http://rd.yahoo.com/SIG=12cb4cj6u/M=258297.4155332.5363524.4049140/D=egroup
web/S=1705115386:HM/EXP=1069623380/A=1683962/R=0/*http://www.techsmith.com/r
dr/ban/syah/default.asp> click here

<http://us.adserver.yahoo.com/l?M=258297.4155332.5363524.4049140/D=egroupmai
l/S=:HM/A=1683962/rand=961139934>

To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com



Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .



[Non-text portions of this message have been removed]