Page 1 of 1

Datatype of Column with TZQuery

Posted: 30.12.2010, 11:27
by mtm
Hy folks,

im a newbie on ZEOS and I have a question. Is there any possibility to get the DataType of the Columns in a Recordset I get from a TZQuery. I know that I can get it form a TSQLMetadata but I want to know, if I can get it from a TZQuery.

thank you
mtm

Posted: 30.12.2010, 16:21
by mdaems
mtm,
Do you want to know the datatype of the database column or do you want to know the type of the TField in the TDataset?
- Getting the database column type isn't possible, as far as I know. Unless TZQuery.FieldDefs(i).DataType works that way, but that would be a zeoslib feature I didn't know. Please test, so we know for sure.
- TField.DataType tells you how the field is interpreted by the dataset.

Mark