Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB Public Beta Tests » View Thread |
Messages 1 to 3 of 3 total |
Length of sql strings |
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. timyoung@elevatesoft.com | 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. timyoung@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 |
This web page was last updated on Monday, May 6, 2024 at 03:23 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |