![]() | ![]() Products ![]() ![]() ![]() ![]() |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB SQL » View Thread |
Messages 1 to 2 of 2 total |
![]() |
Sun, Mar 1 2009 10:14 AM | Permanent Link |
Roy Lambert NLH Associates ![]() | ElevateDB Error #700 An error was found in the statement at line 3 and column 48 (Invalid expression ? found, dynamic parameter references not allowed) SELECT _Date, CAST((CURRENT_DATE - _Date) DAY AS INTEGER) - (:Readings - 1), <<<<<<<<<<<<<<<<<<<<<<<<<< _Dialings, _Connected, _Positive, _Negative, _Score FROM UserStats WHERE _fkStaff = :UserID AND (CURRENT_DATE - _Date) DAY <= :Readings ORDER BY _Date Roy Lambert |
Mon, Mar 2 2009 7:16 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. ![]() | Roy,
<< ElevateDB Error #700 An error was found in the statement at line 3 and column 48 (Invalid expression ? found, dynamic parameter references not allowed) >> It's just the description that we use for parameters in DML statements (SELECT, INSERT, UPDATE, or DELETE). We call them "dynamic" as opposed to parameters for scripts, procedures, etc., which are pre-defined and static. -- Tim Young Elevate Software www.elevatesoft.com |
This web page was last updated on Monday, July 15, 2024 at 07:03 PM | Privacy Policy![]() © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? ![]() |