Tim,

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:

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

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)

Ole Willy Tuv

Hello Ole,

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

Pleeeeeeeeasssssssssseeeeeeee! No more bug posting until the
next build!!!!!

--
Charalabos Michael - [Creation Power] - http://www.creationpower.gr

Ole,

<< 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: >>

No, it's a parsing error.

--
Tim Young
Elevate Software
www.elevatesoft.com