SetSchemaInfo + TFieldType

[ti_duayfabi]

Hello,

I want to retrieve a table schema information with the "SetSchemaInfo" function.
All is fine, I get the columns names, ...
But how can I convert dbExpress types to delphi field type in a simple way?

I wrote a function with many tests and comparisons but it's a shame to maintain that for 3 differents databases.

I'm using delphi 2006 and delphi XE.

Any hint for me?

Thank you.
Kinds regards,

Fabien D.

[AlexP]

Hello,

This method returns not dbExpress type, but database field types. There is no "easy" way to get Delphi types by these types. You have to implement this functionality by yourself.

[Eden0928]

If you use DBX version 4(Delphi 2007 above).
You can get metadata with used DBX MetaData class.