GreatDreamer
Programmer
I have created a parameter called g_dt_EOD_DATE of type DATE. I use this parameter in the SQL as follows:
select
M_END_TIME as EOD_TIME,
M_END_DATE as EOD_DATE
from PCG_AUD_DBF
where M_DATE=:g_dt_EOD_DATE
When I compile and run the report, I get the following error and not sure how to fix it:
NewReportApp::MxBcTextQuerySource3 using the following SQL query:
SELECT M_END_TIME as EOD_TIME, M_END_DATE as EOD_DATE FROM PCG_AUD_DBF WHERE M_DATE=:g_dt_EOD_DATE
Basic Error: 1011 Module: C:\Program Files\Actuate8\ErdPro\afc\db.bas Line: 193 Database Error 10: Cannot execute statement since the parameter(s): g_dt_EOD_DATE do not have values bound. Do you want to debug?
Idle.
There is no data to display.
select
M_END_TIME as EOD_TIME,
M_END_DATE as EOD_DATE
from PCG_AUD_DBF
where M_DATE=:g_dt_EOD_DATE
When I compile and run the report, I get the following error and not sure how to fix it:
NewReportApp::MxBcTextQuerySource3 using the following SQL query:
SELECT M_END_TIME as EOD_TIME, M_END_DATE as EOD_DATE FROM PCG_AUD_DBF WHERE M_DATE=:g_dt_EOD_DATE
Basic Error: 1011 Module: C:\Program Files\Actuate8\ErdPro\afc\db.bas Line: 193 Database Error 10: Cannot execute statement since the parameter(s): g_dt_EOD_DATE do not have values bound. Do you want to debug?
Idle.
There is no data to display.