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

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