Skip to Main Content

Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

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

682000Jun 19 2009 — edited Jul 17 2012
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

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Aug 14 2012
Added on Jun 19 2009
5 comments
13,153 views