Icon View Incident Report

Serious Serious
Reported By: Ole Willy Tuv
Reported On: 3/27/2007
For: Version 1.01 Build 1
# 2287 Correlated Sub-Queries Not Supported in SELECT Column Expressions

The DBISAM Migration Guide states that EDB supports scalar subqueries in the select list:

"ElevateDB supports single-row query expressions as values in the list of selected columns."

I'm not sure if this is an issue with build 1 or you've postponed the functionality to a future point release, but the following query throws the following error:

ElevateDB Error #700 An error was found in the statement at line 5 and column 5 (Invalid expression select found, query expression not allowed)

 FirstName||' '||LastName as Name,
   select count(OrderID)
   from Orders
   where EmployeeID = Employees.EmployeeID
 ) as OrderCount
from Employees

Resolution Resolution
Fixed Problem on 3/28/2007 in version 1.02 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