Home » Developer & Programmer » Forms » SUFFERING FROM THE ERROR ---Frm-41009
SUFFERING FROM THE ERROR ---Frm-41009 [message #85169] Sun, 06 June 2004 22:33 Go to next message
Ravi
Messages: 251
Registered: June 1998
Senior Member
Hi all,

I am getting a error "frm-41009-Function Key not allowed, press cntrl + F1 for the list of valid key's", whenever i am pressing cancel query( to come out of enter query mode)but without performing the query,

I mean to say that this error comes only when i try to canel the query just after entering into the enter query mode, without performing the query., why i am getting this , if i perform a query in enter-query mode and then if i press cancel query it works normally and it does not show this error msg.this error occurs only when i am tring to come out of enter-query without performing the query.Please help me

Besides that can any one guide me how to use 'Exit-query' , for the menu item code of cancel query in forms 6i, Mr. Tang suggested me to do that but i do not know how to do that, please guide me

Ravi
Re: SUFFERING FROM THE ERROR ---Frm-41009 [message #85173 is a reply to message #85169] Mon, 07 June 2004 06:52 Go to previous messageGo to next message
magnetic
Messages: 324
Registered: January 2003
Senior Member

ctrl-q cancels the query if the form is in enter-query mode.
ctrl-qq closes the application.

beside this, do you have a trigger key-others?
if so that couses the error message.

youre comment:
"if i perform a query in enter-query mode and then if i press cancel query it works normally "

this is bullchit, impossible, it should close the form.

next cause might be your keyboard languagesettings and the oracle nls-lang setting in registry.
there is also an oracle file for preferences/settings but i dont remember the name of the file.
maybe another reader ot this message will reply for this.
Re: SUFFERING FROM THE ERROR ---Frm-41009 [message #85185 is a reply to message #85173] Mon, 07 June 2004 22:25 Go to previous messageGo to next message
Himanshu
Messages: 457
Registered: December 2001
Senior Member
Ravi,
Can you provide the code which you have written on Cancel-query button.

Magnetic,please restrian yourself from using such Language in the Forum, I think all of us here are learned & responsible people & it is does not suit us to talk to each other in such a manner.

As for Keybor setting files, it is FMRUSW.RES for client server Forms while FMRWEB.RES for WEBFORMS.
Ravi, remember that these files can be editied using Oracle Terminal only.

Regards
Himanshu
Re: SUFFERING FROM THE ERROR ---Frm-41009 [message #85191 is a reply to message #85185] Tue, 08 June 2004 03:22 Go to previous messageGo to next message
Ravi
Messages: 251
Registered: June 1998
Senior Member
Hey himanshu,
I am using below code in the menu item code of cancel query button
DO_KEY('ABORT_QUERY');
IT is working fine whenever i press cancel-query (but after performing a query in the enter-query mode)and it comes out from enter query mode.
But if i enter into enter query mode and suppose i do not want to query and withour performing query if i press canel query it gives that error msg.

ANOTHER THING IS THAT MR> TANG ASK ME TO USE exit_form IF I A AM USING FORMS6i
BUT I DO NOT KNOW HOW TO USE THAT
COULD YOU PLEASE HELP ME
RAVI
Re: SUFFERING FROM THE ERROR ---Frm-41009 [message #85197 is a reply to message #85191] Tue, 08 June 2004 06:46 Go to previous messageGo to next message
Himanshu
Messages: 457
Registered: December 2001
Senior Member
Hi,
In your Cancel query button write DO_KEY('EXIT_FORM');
Create a trigger at Form Level by the name Key-Exit & write the code as follows:
Begin
Exit_Form(NO_VALIDATE);
End;

HTH
Regards
Himanshu
Re: SUFFERING FROM THE ERROR ---Frm-41009 [message #444496 is a reply to message #85169] Mon, 22 February 2010 04:49 Go to previous messageGo to next message
Tinku_sasidharan
Messages: 1
Registered: February 2010
Location: Bangalore
Junior Member
Hi, Regarding the error "frm-41009" Check the statements between enter_query & execute_query.
In this part if any go_block or any reference statements is mentioned then comment it and try. Please revert back.

[Updated on: Mon, 22 February 2010 05:06]

Report message to a moderator

Re: SUFFERING FROM THE ERROR ---Frm-41009 [message #444500 is a reply to message #85169] Mon, 22 February 2010 05:04 Go to previous message
cookiemonster
Messages: 12320
Registered: September 2008
Location: Rainy Manchester
Senior Member
While we appreciate that you are trying to help, might we suggest you find a thread that isn't 6 years old to help out with. If he hasn't fixed it by now he's never going to.
Previous Topic: Setting the icon at runtime
Next Topic: Form Updation
Goto Forum:
  


Current Time: Sun Sep 25 18:05:54 CDT 2016

Total time taken to generate the page: 0.30639 seconds