Icon View Incident Report

Serious Serious
Reported By: Greg Bishop
Reported On: 2/27/2007
For: Version 1.00 Build 1
# 2242 Using Parameters in Sub-Queries Causes Hard Loop and Lockup

I have the following query. 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). If I execute the query with the parameter, my application freezes.

SELECT ID, Name, Abbreviation FROM
 Analyte
WHERE ID NOT IN
 (SELECT AnalyteID FROM AnalyteToTestMethod
 WHERE TestMethodID = '{D2458D68-4308-46A7-B560-1931C93AB456}')

Parameterized version:

SELECT ID, Name, Abbreviation FROM
 Analyte
WHERE ID NOT IN
 (SELECT AnalyteID FROM AnalyteToTestMethod
 WHERE TestMethodID = :ID)



Comments Comments and Workarounds
The workaround is to use the non-parameterized version.


Resolution Resolution
Fixed Problem on 2/28/2007 in version 1.01 build 1


Products Affected Products Affected
ElevateDB Additional Software and Utilities
ElevateDB VCL Client-Server
ElevateDB VCL Client-Server with Source
ElevateDB VCL Standard
ElevateDB VCL Standard with Source
ElevateDB VCL Trial

Image