Simple string field as Memo

[m227]

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.

Michal

[AlexP]

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 .