Simple string field as Memo

Discussion of open issues, suggestions and bugs regarding LiteDAC (SQLite Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Posts: 59
Joined: Mon 06 Aug 2007 12:41

Simple string field as Memo

Post by m227 » Tue 09 Feb 2016 14:20

Dear Sirs,
I have simple TLiteQuery with SQL:

Code: Select all

SELECT '123' AS test;
When I execute it and try to look at results in Data Editor (or any grid) I get 'test' field as TMemo. I tried to set options.LongStrings to true or false with no change. Delphi 2006, LiteDac 2.5.14.


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

Re: Simple string field as Memo

Post by AlexP » Wed 10 Feb 2016 05:19


If you are using constants, concatenation, aggregating functions (MAX, AVG, ...), etc., SQLite returns the Unknown type for such fields. For correct data display, you should use DataTypeMapping ... apping.htm .

Post Reply