Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB SQL » View Thread |
Messages 1 to 2 of 2 total |
Alternatives for Dynamic references not allowed |
Sat, Mar 28 2009 12:26 PM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Any suggestions. I know I can write the SQL each time but I'd prefer to be able to use parameters
SELECT _Dialings - _Connected AS _Dialings, _Connected - (_Positive + _Negative) AS _Connected, _Positive, _Negative, _Score + (Select MAX(_Dialings) FROM UserStats WHERE _fkStaff = :UserID AND _Date >= :StartDate) AS _Score FROM UserStats WHERE _fkStaff = :UserID AND _Date >= :StartDate ORDER BY _Date --------------------------- Debugger Exception Notification --------------------------- Project Project1.exe raised exception class EEDBException with message 'ElevateDB Error #700 An error was found in the statement at line 6 and column 67 (Invalid expression ? found, dynamic parameter references not allowed)'. --------------------------- Break Continue Help --------------------------- Roy Lambert |
Mon, Mar 30 2009 4:24 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Roy,
<< Any suggestions. I know I can write the SQL each time but I'd prefer to be able to use parameters >> There really isn't any alternative. The problem is simply that EDB doesn't support parameters in SELECT column sub-queries at this time. -- Tim Young Elevate Software www.elevatesoft.com |
This web page was last updated on Tuesday, September 17, 2024 at 04:19 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |