Home » Developer & Programmer » Forms » Bad bind variable error
Bad bind variable error [message #290907] Wed, 02 January 2008 01:55 Go to next message
sgona
Messages: 5
Registered: December 2007
Location: pune
Junior Member
Hi,
When i am creating queryfind in myform, I am getting error in creating the fmx. Like



Compilation error on WHEN-BUTTON-PRESSED trigger on FIND item in QF_BLOCK data block:
PL/SQL ERROR 49 at line 7, column 1
bad bind variable 'PARAMETER.G_QUERY_FIND'
PL/SQL ERROR 49 at line 7, column 1
bad bind variable 'PARAMETER.G_QUERY_FIND'
PL/SQL ERROR 49 at line 9, column 1
bad bind variable 'PARAMETER.G_QUERY_FIND'

Plzzz help me.


[MERGED by LF: please, do not open a new topic about the same problem. There is a "REPLY" button in there to continue discussion.]

[Updated on: Wed, 02 January 2008 04:25] by Moderator

Report message to a moderator

Re: bad bind variable error when creating queryfind. [message #290932 is a reply to message #290907] Wed, 02 January 2008 04:00 Go to previous messageGo to next message
mintomohan
Messages: 104
Registered: November 2006
Location: India
Senior Member
hi,

Can u pls attach the fmb

Minto
bad bind variable error when creating queryfind. [message #290939 is a reply to message #290907] Wed, 02 January 2008 04:13 Go to previous messageGo to next message
sgona
Messages: 5
Registered: December 2007
Location: pune
Junior Member
Hi,

Thans for u r reply.I am attaching fmb here.

When i am creating queryfind in myform, I am getting error in creating the fmx. Like
Compilation error on WHEN-BUTTON-PRESSED trigger on FIND item in QF_BLOCK data block:
PL/SQL ERROR 49 at line 7, column 1
bad bind variable 'PARAMETER.G_QUERY_FIND'
PL/SQL ERROR 49 at line 7, column 1
bad bind variable 'PARAMETER.G_QUERY_FIND'
PL/SQL ERROR 49 at line 9, column 1
bad bind variable 'PARAMETER.G_QUERY_FIND'

It is compling successfully. But when i am generating fmx it is giving error.


Plzzz help me.
Re: bad bind variable error when creating queryfind. [message #290943 is a reply to message #290907] Wed, 02 January 2008 04:22 Go to previous messageGo to next message
Littlefoot
Messages: 20894
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Does your form contain a block named 'parameter'? Is there an item called 'g_query_find'?
Re: bad bind variable error when creating queryfind. [message #290946 is a reply to message #290939] Wed, 02 January 2008 04:27 Go to previous messageGo to next message
vamsi kasina
Messages: 2107
Registered: October 2003
Location: Riyadh, Saudi Arabia
Senior Member
(Or)
Do you think you forgot to define a parameter named G_QUERY_FIND in the Parameters section?

By
Vamsi
Re: bad bind variable error when creating queryfind. [message #290947 is a reply to message #290943] Wed, 02 January 2008 04:31 Go to previous messageGo to next message
Littlefoot
Messages: 20894
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Right; he "forgot" to create a parameter.
Re: bad bind variable error when creating queryfind. [message #291015 is a reply to message #290947] Wed, 02 January 2008 12:53 Go to previous messageGo to next message
Littlefoot
Messages: 20894
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Received via private messaging system:
sgona

Thangs for u r response. This is swathi(sgona). But i created parameter G_QUERY_FIND . I attached my fmb Pls check it once.

I'm sorry, but I don't see it. There's only 'folder_operation_mode' parameter.

./fa/3685/0/
  • Attachment: apinvoice.PNG
    (Size: 4.18KB, Downloaded 5465 times)
Re: bad bind variable error when creating queryfind. [message #291329 is a reply to message #290939] Thu, 03 January 2008 22:41 Go to previous messageGo to next message
mintomohan
Messages: 104
Registered: November 2006
Location: India
Senior Member
hi,

QF_BLOCK.FIND is a text item, and you have added a WHEN-BUTTON-PRESSED trigger on that !!!???

Minto
Re: bad bind variable error when creating queryfind. [message #291383 is a reply to message #291329] Fri, 04 January 2008 01:14 Go to previous messageGo to next message
vamsi kasina
Messages: 2107
Registered: October 2003
Location: Riyadh, Saudi Arabia
Senior Member
Good eyes....../fa/1693/0/

By
Vamsi
Re: bad bind variable error when creating queryfind. [message #291417 is a reply to message #291383] Fri, 04 January 2008 02:42 Go to previous messageGo to next message
mintomohan
Messages: 104
Registered: November 2006
Location: India
Senior Member
thanks Vamsi Smile

i don't think the code in that trigger would ever get executed!

Minto
Re: bad bind variable error when creating queryfind. [message #300326 is a reply to message #290939] Fri, 15 February 2008 01:20 Go to previous message
alayam
Messages: 8
Registered: November 2006
Location: Hyderabad
Junior Member

Set the Form60gen path.

For example in UNIX..

your at custom_top.. in which top you want to generate the fmx ..

Find out the autop path like below example. then run this path in the customtop path.

export FORMS60_PATH=$FORMS60_PATH:/u01/app/appprmc/srceptchappl/au/11.5.0/forms/US

Previous Topic: Function that Return Previous Month of current date
Next Topic: getting error while accessing d2k form builder
Goto Forum:
  


Current Time: Mon Dec 05 10:35:31 CST 2016

Total time taken to generate the page: 0.13476 seconds