Zeoslib Portal

Hi,

is there a way to get the Columntypes of a Table?

I need the Types like (varchar, int, ...) of column. Can anyone help me?

Thanks

Michael

ZQuery.Fields[].DataType should do it...

Hi jeremicm,
thanks for your help, but i need the SQL-Types not the Delphi-Types.
For Example: My Table have a Column FaxNumber an the SQL-Datatyp is Char.

Michael

I don't understand why do you need that but, correct me if I'm wrong, as every database manager uses its own SQL dialect, and Zeos tries to keep separate both kind of types, providing public access only for those you'll actually need to write an application (which are the Delphi ones), I'm afraid that the easiest way of doing that is accessing the metadata of the underlying database directly using SQL code... Which is, of course, not portable.

You can always do SHOW CREATE TABLE tblname (for mysql, or similar for database you use) and parse result for column you need...