Oracle Forms

Hello Everyone,

I have a problem with enter query mode. Let say i'm in the enter query mode, and i click on a button. I will get the error FRM-41009 displayed.

Now, i wanted to handled it. So i created an on-error trigger to handle the error.

IF ERR_CODE= 41009 THEN
NULL;
END IF;

One problem is that when using null, it does not exit the enter query mode, and then i get the error frm 40301.

Second problem is that i cannot use exit_form in an on-error trigger.

I'm aware that i can press F4 to exit this mode but i dont want to make the user do it each time as i'm sure i'll get complaints.

Another solution would be to put the following code in the when-button-pressed trigger for each button in the form:

if :system.mode='ENTER-QUERY' then
exit_form;
end if;

But i dont want to replicate this code everywhere in my form.

Please can you provide me with an idea how to handle this properly ?

Thank you,
Michaël

PS : Version of form => ORACLE FORMS 10g (Forms [32 Bit] Version 10.1.2.3.0 )