OraFAQ Forum: Forms » bad bind variable parameter.G_query

Home » Developer & Programmer » Forms » bad bind variable parameter.G_query_find (Forms builder 10.1.2)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

bad bind variable parameter.G_query_find [message #639076]

Wed, 01 July 2015 04:51

dpit
Messages: 3
Registered: July 2015
Location: Netherlands

Junior Member

Hi,

I'm a newbie in Forms.
A former colleague has created a custom form and I now need to add an extra field.

When compiling the fmb file to an fmx file in a Linux prompt, I get this error:

Compiling WHEN-BUTTON-PRESSED trigger on FIND item in CUST_QF data block...
Compilation error on WHEN-BUTTON-PRESSED trigger on FIND item in CUST_QF data block:
PL/SQL ERROR 49 at line 1, column 1
bad bind variable 'parameter.G_query_find'
PL/SQL ERROR 49 at line 1, column 1
bad bind variable 'parameter.G_query_find'
PL/SQL ERROR 49 at line 3, column 1
bad bind variable 'parameter.G_query_find'

I have not touched that part of the form.
When I try to compile the previous/existing fmb file, I get the same error so I'm not sure how they compiled it before?

I attached the fmb file. I had to zip it as it's larger than 2MB. However, .zip is not accepted so I renamed it to .fmb.
So please rename the extension to .zip first to extract the fmb file.

Hopefully someone is willing to take a look at this to see what is wrong.

Thanks in advance,
Richard

Attachment: XXDPICUST_zipped.fmb
(Size: 468.50KB, Downloaded 1638 times)

Report message to a moderator

Re: bad bind variable parameter.G_query_find [message #639078 is a reply to message #639076]

Wed, 01 July 2015 05:09

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

(I can't open that form with my Forms Builder so ...)

It seems that WHEN-BUTTON-PRESSED trigger on FIND item in CUST_QF data block references a parameter whose name is G_query_find, but it doesn't exist among parameters declared in that form.

Report message to a moderator

Re: bad bind variable parameter.G_query_find [message #639080 is a reply to message #639078]

Wed, 01 July 2015 06:30

dpit
Messages: 3
Registered: July 2015
Location: Netherlands

Junior Member

Hi,

Did you rename the file to .zip first and then extract the zip file to get the form?

Report message to a moderator

Re: bad bind variable parameter.G_query_find [message #639081 is a reply to message #639080]

Wed, 01 July 2015 06:39

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

I have the FMB, but your and my Forms version are different. I don't see any items nor program units.

However, I saw the parameter's list, and there's no G_query_find parameter in there. Try to add it. Can't tell what would be its data type; if you aren't sure either, set it to Character and try to recompile the form.

Report message to a moderator

Re: bad bind variable parameter.G_query_find [message #639087 is a reply to message #639081]

Wed, 01 July 2015 07:21

dpit
Messages: 3
Registered: July 2015
Location: Netherlands

Junior Member

Hi,

There is actually a parameter G_QUERY_FIND:

/forum/fa/12746/0/

Attachment: parameter.JPG
(Size: 120.16KB, Downloaded 5032 times)

Report message to a moderator

Re: bad bind variable parameter.G_query_find [message #639097 is a reply to message #639087]

Wed, 01 July 2015 09:43

CraigB
Messages: 386
Registered: August 2014
Location: Utah, USA

Senior Member

Your picture says it all. The G_QUERY_FIND parameter is subclassed. Therefore, you need to make sure your environment is configured correctly to find all of the depended files when you compile. In other words, you need to make sure your FORMS_PATH includes the directory where the source object (.fmb or .olb) for these subclassed object resides. If the Forms Compiler can't find the source object, you will get the error you are getting.

Craig...

Report message to a moderator

Re: bad bind variable parameter.G_query_find [message #639101 is a reply to message #639097]

Wed, 01 July 2015 13:34

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Right; I didn't see any subclassed parameters.

Report message to a moderator

Previous Topic:	problem in clearing data from related data blocks in oracle forms
Next Topic:	concate two colulmns

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Feb 08 17:33:35 CST 2025