Devart Forums

Posted: **Tue 09 Feb 2016 14:20**

Dear Sirs,
I have simple TLiteQuery with SQL:

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.

Michal

Posted: **Wed 10 Feb 2016 05:19**

Hello,

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 http://www.devart.com/litedac/docs/data ... apping.htm .

Devart Forums

Simple string field as Memo

Simple string field as Memo

Re: Simple string field as Memo