Persistent Fiels

Discussion of open issues, suggestions and bugs regarding LiteDAC (SQLite Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Posts: 6
Joined: Fri 04 Jul 2008 08:25
Location: Italy

Persistent Fiels

Post by azago » Fri 01 Apr 2016 14:32

i have created a Query
, 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

Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: Persistent Fiels

Post by AlexP » Mon 04 Apr 2016 03:55


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 ... apping.htm .

Post Reply