Problem TSQLQuery.SQL.Text length (SOLVED)

[xinyiman]

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

[xenblaise]

try
TSQLQuery.SQL.DelimitedText :=

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

[xinyiman]

Thank you!

[xenblaise]

This?
TSQLQuery.SQL.DelimitedText := ?
 

[xinyiman]

This?
TSQLQuery.SQL.DelimitedText := ?
 

No! When

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

[krexon]

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]

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