Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Parameter in SQL Values Bound ERROR

Status
Not open for further replies.

GreatDreamer

Programmer
Feb 11, 2006
15
CA
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.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top