This discussion is archived
5 Replies Latest reply: Jul 17, 2012 8:59 AM by InoL RSS

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

682000 Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points