5 Replies Latest reply: Jul 17, 2012 10:59 AM by InoL

FRM-41003: "This function cannot be performed here" error help!

682000 Jun 19, 2009 6:06 AM

Hi ,
I need to do a query on a multi-record block form. The block(employee) has the following fields

emp_no emp_name emp_address start_date finish_date (in employee block)

The query is to find employees whose start_date is between DATE1 and DATE2
So I create 2 control items DATE1 and DATE2
My plan is after user enter DATE1 and DATE2 and click execute query button then in
key-exeqry:
go_block('EMPLOYEE');
Set_Block_Property('EMPLOYEE',DEFAULT_WHERE,'start_date between :control.date1 and :control.date2');
execute_query;

When I click enter query icon and I always get FRM-41003: "This function cannot be performed here"

Could you tell me what cause this error and how to fix it.

Also I need do the validate to make sure DATE2>DATE1. I put this validate in execute-query trigger and does the job.
Is this the right place to put this validation?

Many Thanks
Michael

1. Re: FRM-41003: "This function cannot be performed here" error help!

496663 Jun 19, 2009 6:50 AM (in response to 682000)

Hi, try do it in the trigger "PRE-QUERY".

Regards
Like Show 0 Likes (0)

Actions
2. Re: FRM-41003: "This function cannot be performed here" error help!

682000 Jun 19, 2009 8:30 AM (in response to 496663)

Hi Jesus,

Thanks for your help. The validation work fine in pre-query. Could you also shed some light on error FRM-41003: "This function cannot be performed here" as well?

Many thanks
Michael
Like Show 0 Likes (0)

Actions
3. Re: FRM-41003: "This function cannot be performed here" error help!

928095 Jul 17, 2012 12:42 AM (in response to 682000)

Hi Michael ,
I had tried it in pre-query but .. I found the same error..

-- Shubham
Like Show 0 Likes (0)

Actions
4. Re: FRM-41003: "This function cannot be performed here" error help!

CraigB Jul 17, 2012 9:21 AM (in response to 682000)

Michael,
It sounds like you have a trigger that is firing (like a When-Validate-Item) when you are not expecting it to fire. If you are able to run your form from the Forms Builder, I recommend you run your form with Debug Messages turned on to see what is firing when you click the "Execute Query" button. If you can't run from the Forms Builder, then I recommend you enable "Tracing" and run your form. Then review the trace log to see what is actually causing your error. Once you know the actual source of your error you will be able to resolve it.

Hope this helps,
Craig B-)

If someone's response is helpful or correct, please mark it accordingly.
Like Show 0 Likes (0)

Actions
5. Re: FRM-41003: "This function cannot be performed here" error help!

InoL Jul 17, 2012 10:59 AM (in response to 682000)

FRM-41003: "This function cannot be performed here"
My plan is ... click execute query button
When I click enter query icon
So, when do you click enter query? If you input the dates in a control block, there is no enter query.
Like Show 0 Likes (0)

Actions

Go to original post