Icon View Incident Report

Serious Serious
Reported By: John Hay
Reported On: 7/17/2008
For: Version 2.01 Build 1
# 2708 Derived Tables Cause a Scalar Sub-Query Error

I tried running the following query and it gives a "scalar query can only return a single value" error. The error is for the innermost SELECT statement.

UPDATE Zwei SET Zahl_3 =
SELECT Zahl_1,Zahl_2,COUNT(*) AS tot FROM
(SELECT Zahl_1,Zahl_2,total.runde,count(*) from Zwei
JOIN total ON total.zahl=Zwei.Zahl_1 or total.zahl=Zweir.Zahl_2
GROUP by Zahl_1,Zahl_2,total.runde
HAVING COUNT(*) > 1) t1
GROUP BY Zahl_1,Zahl_2) t2
WHERE Zwei.Zahl_1=t2.Zahl_1 and Zwei.Zahl_2=t2.Zahl_2)

Resolution Resolution
Fixed Problem on 7/19/2008 in version 2.01 build 2

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