Problem TSQLQuery.SQL.Text length (SOLVED)
lazarus / 16-Databases

----------------------------------------------------------------------
xinyiman · 2010-10-20 09:45

I have a query longer than 255 characters, and when I run crashes. How
do you solve? Thanks

----------------------------------------------------------------------
xenblaise · 2010-10-20 10:04

try
TSQLQuery.SQL.DelimitedText :=

or
TSQLQuery.SQL.Clear;
TSQLQuery.SQL.Add('drop .....  ;');
TSQLQuery.SQL.Add('create .....  ;');
TSQLQuery.SQL.Add('select .....  ');

----------------------------------------------------------------------
xinyiman · 2010-10-20 10:15

Thank you!

----------------------------------------------------------------------
xenblaise · 2010-10-22 00:21

This?
TSQLQuery.SQL.DelimitedText := ?

----------------------------------------------------------------------
xinyiman · 2010-10-22 03:36

Quote from: xenablaise on October 22, 2010, 02:21:21 amThis?
TSQLQuery.SQL.DelimitedText := ?

No! When

TSQLQuery.SQL.Clear;
TSQLQuery.SQL.Add('drop .....  ;');
TSQLQuery.SQL.Add('create .....  ;');
TSQLQuery.SQL.Add('select .....  ');

----------------------------------------------------------------------
krexon · 2010-10-22 07:20

I often have over 5000 chars in queries and never had problems.
I do it in this way:
Code: [Select]var q: string;
...
q:='';
q:=q+'SELECT ....';
q:=q+'UNION...';
q:=q+....';
...
SQLQuery.SQL.Text:=q;
SQLQuery.Open;
while not SQLQuery.EOF do
 begin
  SQLQuery.Next;
 end;
SQLQuery.Close;

----------------------------------------------------------------------
xenblaise · 2010-10-23 09:48

smartcode
seems we fogot that when were going up.
move forward