Home » Developer & Programmer » Forms » FRM-41003: "This function cannot be performed here"
FRM-41003: "This function cannot be performed here" [message #607130] Mon, 03 February 2014 02:49 Go to next message
mist598
Messages: 698
Registered: February 2013
Location: Hyderabad
Senior Member
Hi,

The Orders form has two base table blocks and a control block. There is an Execute Query button in the control block with the following When-Button-Pressed trigger.

DO_KEY('execute_query);


A user navigates to the Order Items block and clicks Execute Query. The query does not execute, but instead returns error FRM-41003: "This function cannot be performed here".
What can i do to fix this error?

Thank You
Re: FRM-41003: "This function cannot be performed here" [message #607131 is a reply to message #607130] Mon, 03 February 2014 02:51 Go to previous messageGo to next message
cookiemonster
Messages: 10573
Registered: September 2008
Location: Rainy Manchester
Senior Member
execute_query (and enter_query) only works in database blocks, not control blocks. So you would first have to navigate to a database block.
Re: FRM-41003: "This function cannot be performed here" [message #607132 is a reply to message #607131] Mon, 03 February 2014 02:54 Go to previous messageGo to next message
mist598
Messages: 698
Registered: February 2013
Location: Hyderabad
Senior Member
Thank You for early reply cookiemonster.. Smile, Can you please eloborate me
Re: FRM-41003: "This function cannot be performed here" [message #607133 is a reply to message #607130] Mon, 03 February 2014 03:07 Go to previous messageGo to next message
mist598
Messages: 698
Registered: February 2013
Location: Hyderabad
Senior Member
I Set the Mouse Navigate property to No for the Execute Query button. Now it worked fine.. Smile
Re: FRM-41003: "This function cannot be performed here" [message #607135 is a reply to message #607133] Mon, 03 February 2014 03:12 Go to previous messageGo to next message
cookiemonster
Messages: 10573
Registered: September 2008
Location: Rainy Manchester
Senior Member
personally I would have added a go_block statement to move the cursor to the block you wanted to execute a query in.
Re: FRM-41003: "This function cannot be performed here" [message #607136 is a reply to message #607135] Mon, 03 February 2014 03:15 Go to previous message
mist598
Messages: 698
Registered: February 2013
Location: Hyderabad
Senior Member
Quote:
personally I would have added a go_block statement to move the cursor to the block you wanted to execute a query in.


Yes you are right cookiemonster.. Smile

Thank You Very Much.. Smile
Previous Topic: How to apply spell Check of Forms 11g
Next Topic: how configure 10g form fmx same machine
Goto Forum:
  


Current Time: Mon Apr 21 00:35:49 CDT 2014

Total time taken to generate the page: 0.10568 seconds