Devart Forums

Hello,

I would like to know the type of a field in a table (char decimal date ...)
How could i do?

Thank you for help

Regards

IBDAC does not have such feature.

You don't need any components for that.

You can make a simple select statement to get the information from the Firebird system tables.

I don't know which system table holds field types, look it up.

Here is some example code, this selects stored procedure data from the database:
SELECT * FROM RDB$PROCEDURES

So you'll be looking at RDB$... tables!

Good luck,
Zd

Execute query like this:

select rdb$field_source from rdb$relation_fields where rdb$relation_name = :TableName and rdb$field_name=:FieldName

Good Luck!