OraFAQ Forum: Forms » FRM-41003: "This function cannot be performed here"

Home » Developer & Programmer » Forms » FRM-41003: "This function cannot be performed here"

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

FRM-41003: "This function cannot be performed here" [message #607130]

Mon, 03 February 2014 02:49

mist598
Messages: 1195
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

Report message to a moderator

Re: FRM-41003: "This function cannot be performed here" [message #607131 is a reply to message #607130]

Mon, 03 February 2014 02:51

cookiemonster
Messages: 13920
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.

Report message to a moderator

Re: FRM-41003: "This function cannot be performed here" [message #607132 is a reply to message #607131]

Mon, 03 February 2014 02:54

mist598
Messages: 1195
Registered: February 2013
Location: Hyderabad

Senior Member

Thank You for early reply cookiemonster.. Smile

, Can you please eloborate me

Report message to a moderator

Re: FRM-41003: "This function cannot be performed here" [message #607133 is a reply to message #607130]

Mon, 03 February 2014 03:07

mist598
Messages: 1195
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

Report message to a moderator

Re: FRM-41003: "This function cannot be performed here" [message #607135 is a reply to message #607133]

Mon, 03 February 2014 03:12

cookiemonster
Messages: 13920
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.

Report message to a moderator

Re: FRM-41003: "This function cannot be performed here" [message #607136 is a reply to message #607135]

Mon, 03 February 2014 03:15

mist598
Messages: 1195
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

Report message to a moderator

Previous Topic:	How to apply spell Check of Forms 11g
Next Topic:	how configure 10g form fmx same machine

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 09:58:12 CDT 2024