Devart Forums

i have created a Query
----------------------
SELECT
CodAgente
, NomeAgente
, (Select Count(CodAgente) From Clienti Where CodAgente = Agenti.CodAgente
AND Modify = 1) As AggClienti
, EMail
From Agenti
--------------------

The Query Working correctly.

When i you want create Persistent Field in Query for adjusting the video layout,
the field AggClienti want return type TMemoField and not TIntegerField

i use
--------
Delphi 2010 Enterprise
Litedac 2.6.21

Angelo Zago

Hello,

If you are using concatenation, aggregating functions (MAX, AVG, ...), nested queries, etc., SQLite returns the Unknown type for such fields. For correct create fields and data display, you should use DataTypeMapping http://www.devart.com/litedac/docs/data ... apping.htm .