Page 1 of 1

SetSchemaInfo + TFieldType

Posted: Wed 01 Oct 2014 13:22
by 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.

Re: SetSchemaInfo + TFieldType

Posted: Thu 02 Oct 2014 13:19
by 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.

Re: SetSchemaInfo + TFieldType

Posted: Mon 27 Apr 2015 01:45
by Eden0928
If you use DBX version 4(Delphi 2007 above).
You can get metadata with used DBX MetaData class.