SQLite3 concat string problem

[uea]

Hi,

I am using the TSQLite3Connection, TSQLQuery and the TSQLTransaction accessing to my sqlite db.

In one of my queries I use "group_concat" of sqlite3 and generate a return string of bigger than 2000 chars. I can see that

select
   group_concat('"' || name || '"' || ' ' || format)  as srcsql
from
   mytable;

actually works because I can run it in a db editor. Return is correct and 2346 chars.

Nevertheless, only 1021 chars return within the pascal code. I cannot understand if this is the limitation of TSQLQuery , pascal or the sqlite3?

I have also tried the below casting, but it did not work either.

select
   cast(group_concat('"' || name || '"' || ' ' || format) as varchar(5000))  as srcsql
from
   mytable;

Any opinions where to look at?

using

• lazarus 3.0
  
• pascal 3.2.2
  
• windows 10
  

My Solution 
Apparently, although there is only 1 row with 1 column, I am not waiting for query to be finalized. I did below and it worked.

With query do
  While not EOF do
  begin
     SQLsrc:=FieldByName('srcsql').AsString;
     Next;
  end;   

[Chris78]

Hi,

perhaps you can use  “group_concat_max_len” to modify the limit ?

[essence-ciel]

Hello,
I don't know if this can help you, but edit the fields in your SqlQuery, click on the relevant field and you'll find a "Size" item. It sets a number of characters to be displayed.