Hi,
how can I display in a DBGrid field (using sqlite3) a sql expression e.g. MAX(aDate) in right date display format?
I used at an old project the sql 'SELECT MAX(aDate) FROM Table1'
without problem until Laz v.1.6.4 , as I remember.
I noticed that from Laz v.1.8.2 and then, fields with MAX() data are display as (MEMO).
I seems that max() is been FieldTYpe: ftMemo and trying to CAST it, it becomes ftLargeint
How can I solve it? I tried to find a solution but I failed.
Thanks in advance.
I attach a simple example.