Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 10 of 14 total |
GUID as Parameter in TEDBQuery |
Mon, Feb 26 2007 12:21 PM | Permanent Link |
"Greg Bishop" | I have the following query:
SELECT ID, Name, Abbreviation FROM Analyte WHERE ID NOT IN (SELECT AnalyteID FROM AnalyteToTestMethod WHERE TestMethodID = '{D2458D68-4308-46A7-B560-1931C93AB456}') When I execute this in a TEDBQuery component, it works as expected. Next, I revised the query to include a parameter (which is a GUID field in another DataSet) like this: SELECT ID, Name, Abbreviation FROM Analyte WHERE ID NOT IN (SELECT AnalyteID FROM AnalyteToTestMethod WHERE TestMethodID = :ID) If I execute the query with the parameter, my application freezes. I'm not sure if this is EDB specific or not, but any thoughts on how to get the parameter to work properly would be appreciated. I'm using Delphi 7.1 Pro with ElevateDB 1, Build 1 |
Mon, Feb 26 2007 1:40 PM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Greg
How are you setting the parameter? Roy Lambert |
Mon, Feb 26 2007 1:45 PM | Permanent Link |
"Greg Bishop" | I am setting it via the DataSource property of the TEDBQuery component. The
DataSource I'm using has an ID field. |
Tue, Feb 27 2007 7:01 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Greg,
<< When I execute this in a TEDBQuery component, it works as expected. Next, I revised the query to include a parameter (which is a GUID field in another DataSet) like this: SELECT ID, Name, Abbreviation FROM Analyte WHERE ID NOT IN (SELECT AnalyteID FROM AnalyteToTestMethod WHERE TestMethodID = :ID) If I execute the query with the parameter, my application freezes. >> Got it. It's a hard loop caused by parameters in sub-queries. Build 2 will fix it. -- Tim Young Elevate Software www.elevatesoft.com |
Wed, Oct 3 2007 5:26 AM | Permanent Link |
Peter Thorne | Tim
I'm not sure if this is quite fixed yet. The following SQL hangs the ide when active is set to true (:tree_id is set from a datasource attached to a TEDBTable) ... SELECT * FROM TreeStructures JOIN TreeBoxes ON TreeStructures.box_id = TreeBoxes.box_id WHERE TreeStructures.tree_id = :tree_id I've checked creation order (for the TEDBTable and the TDataSource) and set an initial value for the parameter as suggested elsewhere. "tree_id" in the master table is autoinc and integer in "TreeStructures". Version is 1.05. A problem with the JOIN? Peter |
Thu, Oct 4 2007 11:17 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Peter,
<< I'm not sure if this is quite fixed yet. The following SQL hangs the ide when active is set to true (:tree_id is set from a datasource attached to a TEDBTable) ... SELECT * FROM TreeStructures JOIN TreeBoxes ON TreeStructures.box_id = TreeBoxes.box_id WHERE TreeStructures.tree_id = :tree_id I've checked creation order (for the TEDBTable and the TDataSource) and set an initial value for the parameter as suggested elsewhere. "tree_id" in the master table is autoinc and integer in "TreeStructures". Version is 1.05. A problem with the JOIN? >> There are two separate issues that are outstanding with 1.05 that could cause this issue, one with parameters and one with non-sensitive query result sets (which this is). Is the application flat out hanging, or is the CPU still being consumed for the application ? -- Tim Young Elevate Software www.elevatesoft.com |
Fri, Oct 5 2007 3:07 AM | Permanent Link |
Peter Thorne | "Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote:
<< There are two separate issues that are outstanding with 1.05 that could cause this issue, one with parameters and one with non-sensitive query result sets (which this is). Is the application flat out hanging, or is the CPU still being consumed for the application ? >> It's away with the fairies - flat out. I have to close the IDE through task manager. -- Tim Young Elevate Software www.elevatesoft.com |
Mon, Oct 8 2007 11:53 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Peter,
<< It's away with the fairies - flat out. I have to close the IDE through task manager. >> So, it is using the CPU ? I'm assuming that "flat out" means that, but just checking. -- Tim Young Elevate Software www.elevatesoft.com |
Tue, Oct 9 2007 4:17 AM | Permanent Link |
Peter Thorne | No sorry. I should have been clearer. There doesn't appear to be any significant CPU activity due to the query ...
|
Wed, Oct 10 2007 8:45 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Peter,
<< No sorry. I should have been clearer. There doesn't appear to be any significant CPU activity due to the query ... >> Hmmm, it still sounds like the same issue with parameterized execution that has already been fixed, but if you'd like to send me the query and tables I can definitely confirm this before 1.06 is released. -- Tim Young Elevate Software www.elevatesoft.com |
Page 1 of 2 | Next Page » | |
Jump to Page: 1 2 |
This web page was last updated on Tuesday, May 7, 2024 at 06:25 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |