[SOLVED] TSQLQuery.ParseSQL strange behavior

[swierzbicki]

Hello,

I'm using TSQLQuery with TPQConnection.
"Calculated SQL fields" are not fetched into TSQLQuery.Fields

Such a basic SQL statement can reproduce the problem :

Code: [Select]

Select
'MY STRING' as MyCalculedField
Table.FieldA,
Table.FiedB
From Table
TSQLQuery.FieldsCount will return 2 instead of 3.
Only physical fields will be fetched and the 'calculated' one will never show.

How can I correct this ?

[LacaK]

Try use:
 cast('MY STRING' as char(9)) as MyCalculatedField

[swierzbicki]

Thank you , this is working