TMemoField instead of TStringField.

[BSaidus]

Hello.
I use TZQuery from ZeosDBO and I have a an SQLITE View witch is an SQL aggregation of some fields from different tables.
Say
   vtmp_1 is a view, and
   f1: a VARCHAR field,
   f2: a VARCHAR field,
   f3: a VARCHAR field,
   f4: an aggregated field => CAST(('aa_'||LOWER(REPLACE(name, ' ', '_'))||'="'||fname||'"') AS VARCHAR) AS ENAME
When I use an SQL SELECT Statement in a ZQuery, I got "f4" as TMemoField
In every cases,

Code: SQL  [Select][+][-]

1. SELECT  f1,
2.         f2,
3.         f3,
4.         f4
5.    FROM vtemp_1;  
6.  
7. SELECT  f1,
8.         f2,
9.         f3,
10.         CAST(f4 AS VARCHAR) AS f4
11.    FROM vtemp_1;
12.  

So Is there any solution for this, I need it to use this fied as a Lookup field in TDBLookupComboBox ( Now it display (memo) as content ).

Thank you.

[Zvoni]

IIRC, you have to implement the OnGetText-Event for the Field

This is similiar to your problem:
https://forum.lazarus.freepascal.org/index.php/topic,69567.msg540683.html#msg540683

Edit: an alternative approach might be to use generated columns from the get go instead of concatenating it in the query/view
But this depends, if the used fields for f4/ename are from the same table

[BSaidus]

IIRC, you have to implement the OnGetText-Event for the Field

This is similiar to your problem:
https://forum.lazarus.freepascal.org/index.php/topic,69567.msg540683.html#msg540683

Edit: an alternative approach might be to use generated columns from the get go instead of concatenating it in the query/view
But this depends, if the used fields for f4/ename are from the same table

Thanks @Zvoni.
It works well, I will investigate the 2nd method.
Thnks again.

[Zvoni]

Thanks @Zvoni.
It works well, I will investigate the 2nd method.
Thnks again.

As for the second (alternative) Approach (Generated Columns):
Could you post the CREATE-Statement for that View?

The crucial part is this

f4: an aggregated field => CAST(('aa_'||LOWER(REPLACE(name, ' ', '_'))||'="'||fname||'"') AS VARCHAR) AS ENAME

"name" and "fname": Are these two fields in the same table?
If yes, then i would definitely go with generated Columns instead of "calculating" it via query and then Type-Casting it from here to Moscow
If no (they are in separate tables), then your current solution is the only viable way