Use parameter in SQL Editor

EdS125

Goodday everybody,

I hope i have a simple question. I'm trying to use a parameter in sql editor mode. But the editor gives an error when confirming. Ive tried using () whit the parameter but is does not work. Can anyone give me a push in the right direction?

SELECT REP.PROJECT_NUMBER
, REP.PROJECT_DESC
, REP.PHASE_NUMBER
, REP.PHASE_DESC
, REP.INVOICE_DATE
, sum(iif(REP.invoice_date < :Date, REP.AMOUNT, 0)) as BEFORE_AMOUNT
, sum(iif(REP.invoice_date >= :Date, REP.AMOUNT, 0)) as AFTER_AMOUNT
from VW_REP_PHASE_INVOICE_AMOUNT REP

nardmoseley

Hi Edward,

Please update your profile with the registered email address for the license.

We only have resources to provide tech support to Delphi developers with an active RB license.