![]() | ![]() Products ![]() ![]() ![]() ![]() |
Home » Technical Support » ElevateDB Technical Support » Support Forums » Search Forums » Search Results » View Thread |
Messages 1 to 3 of 3 total |
![]() |
Thu, Jan 4 2007 7:36 AM | Permanent Link |
"Edhrx" | 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 |
Thu, Jan 4 2007 4:48 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. ![]() | 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 |
Thu, Jan 4 2007 11:15 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. ![]() | 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 |
This web page was last updated on Saturday, June 22, 2024 at 05:51 PM | Privacy Policy![]() © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? ![]() |