Hi
I quite often create a temporary table like so

   q:= TEDBQuery.Create(nil);
   q.SessionName:= self.sessionMain.SessionName;
   q.DatabaseName:= self.dbR.DatabaseName;
   q.SQL.Text:= sql ;
   q.ExecSQL;

However it fails, truncating the sql text  when the SQL string is > 250
It also does if you add it a line at time q.sql.add('blah blah');

best wishes Ed

Ed,

<< However it fails, truncating the sql text  when the SQL string is > 250
It also does if you add it a line at time q.sql.add('blah blah'); >>

I will look into this.

--
Tim Young
Elevate Software
www.elevatesoft.com

Ed,

<< I quite often create a temporary table like so

   q:= TEDBQuery.Create(nil);
   q.SessionName:= self.sessionMain.SessionName;
   q.DatabaseName:= self.dbR.DatabaseName;
   q.SQL.Text:= sql ;
   q.ExecSQL;

However it fails, truncating the sql text  when the SQL string is > 250 It
also does if you add it a line at time q.sql.add('blah blah'); >>

I can't replicate this - I tried it with a 4500 byte SQL query in EDB and it
works fine.  What version of Delphi are you using ?

--
Tim Young
Elevate Software
www.elevatesoft.com