Home » Developer & Programmer » Forms » Bad Bind Variable
Bad Bind Variable [message #84764] Thu, 22 April 2004 12:48 Go to next message
David Izzard
Messages: 3
Registered: April 2004
Junior Member
I have a form which has the text field PROJECT_ID on it.  The form is based on a datablock which pulls information for projects including the project_id.  The for was working fine yesterday, but today it won't compile.  I get the message "bad bind variable" when comiling.  The code that gernerates the error is below:

BEGIN
Go_Block('Project');
Execute_Query;
:PARAMETER.PROJECT_ID := :PROJECT_ID;
END;

The weird thing is when I delete the text field PROJECT_ID, it compiles fine, but of course doen't run properly because I need the value from PROJECT_ID.  Anyone encounter this before?  Any solutions?

Cheers,

Dave
Re: Bad Bind Variable [message #84768 is a reply to message #84764] Fri, 23 April 2004 04:09 Go to previous message
magnetic
Messages: 324
Registered: January 2003
Senior Member
:PROJECT_ID; should be :blockname.project_id;
Previous Topic: anyone! , please look into my previous problem
Next Topic: calling oracle form from batch file
Goto Forum:
  


Current Time: Mon May 20 15:28:12 CDT 2024