Macros are not identified.

easyblue · Post by **easyblue** » Wed 02 Dec 2009 16:42

Hello

version v6.90.0.53+BDS2006

with following SQL, the two macros are not able to be identified into Macros.

select *
from dpa
where dpa.PERIOD_START_TIME >=
to_date('&start_datetime', 'yyyymmddhh24')
and dpa.PERIOD_START_TIME <=
to_date('&end_datetime', 'yyyymmddhh24')

Please kindly check it

Plash · Post by **Plash** » Thu 03 Dec 2009 12:37

You cannot use macros inside string constants. Remove quotes from the macro name. Assing a value with quotes for the macro instead.