Oracle Forms Developer 6i: EXECUTE_QUERY do not working after ENTER_QUERY Mode

Question

I have 2 data block 'Employee' as master and 'Employee_Details' as details and 1 control block for navigation. I have used my menu and usually the default developer toolbar was not appeared. So I place a Enter-Query button to serve the purpose. I used when-button-pressed trigger.

GO_BLOCK('EMPLOYEE');
IF :System.Mode = 'NORMAL' THEN 
    Enter_Query;
ELSE
    EXECUTE_QUERY;
END IF;

In first trigger the Form goes to Enter-Query Mode. But when I pressed for Execute_Query it does not work. Rather it shows in status bar to press F8 to do query and Ctrl+q for cancel. I tried it to place the code in different button but not working. I do not want to press F8 for execute query. Why my button code not working for Executing Query? Have you any solution?

Please clarify: have you deliberately suppressed the default toolbar? If not, shouldn't you be trying to solve that problem instead? — APC
In fact I got an answer from another forum. This method will work only with default where clause. The built-in enter_query and execute_query system only available in default toolbar. — Iqbal Hossain
Please write that up as an answer, and accept it (when SO allows you to). — APC
I'm sure that you are able to use built-ins Enter_Query and Ececute_Query even if you don't use the default toolbar. — Peter Å

nightfox79 nightfox79 · Accepted Answer · 2013-06-30T20:38:51

The problem probably is that there are a few options with your trigger. One of them is if it will fire when in enter query mode. Because you are in enter-query mode right now this switch should be true. Then it will work.

The default for the switch is false, so no trigger will fire in enter-query mode.

Oracle Forms Developer 6i: EXECUTE_QUERY do not working after ENTER_QUERY Mode

1 Answers