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

Report message to a moderator

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.

Report message to a moderator

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

Report message to a moderator

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

Report message to a moderator

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

Report message to a moderator

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: 13963
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.

Report message to a moderator

Previous Topic: Setting the icon at runtime
Next Topic: Form Updation
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Feb 10 04:37:54 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.