Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 3 of 3 total |
Scalar subquery in the select list |
Tue, Mar 27 2007 11:04 AM | Permanent Link |
"Ole Willy Tuv" | 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 |
Tue, Mar 27 2007 7:32 PM | Permanent Link |
Charalabos Michael | 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 |
Wed, Mar 28 2007 7:10 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | 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 |
This web page was last updated on Saturday, May 4, 2024 at 12:54 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |