Home » Developer & Programmer » Forms » problem of message do you want to save changes ... when I press on button that make execute query (Oracle 10g, forms builder, windows 10)
problem of message do you want to save changes ... when I press on button that make execute query [message #678880] Sun, 19 January 2020 16:25 Go to next message
Oraclinho
Messages: 9
Registered: December 2018
Junior Member
when I execute query through button in menu to form ...

this message appeared ... message do you want to save changes?

I want to forbid this message from appearing and execute query without it ... what is the reason of appearing it?

this is code of key exit trigger:


DECLARE
V_EXIT ALERT:=FIND_ALERT('EXIT');
V_NEXIT NUMBER;
V_SAVE ALERT:=FIND_ALERT('SAVE');
V_NSAVE NUMBER;
BEGIN
IF :SYSTEM.FORM_STATUS='CHANGED' THEN
V_NSAVE:=SHOW_ALERT(V_SAVE);
IF V_NSAVE = ALERT_BUTTON1 THEN
:SYSTEM.MESSAGE_LEVEL:=20;
COMMIT;
EXIT_FORM(NO_VALIDATE);
ELSIF V_NSAVE = ALERT_BUTTON2 THEN
EXIT_FORM(NO_VALIDATE);
ELSE
NULL;
END IF;
ELSE
V_NEXIT:=SHOW_ALERT(V_EXIT);
IF V_NEXIT= ALERT_BUTTON1 THEN
EXIT_FORM(NO_VALIDATE);
ELSE
NULL;
END IF;
END IF;
END;


how can I forbid it from showing??

any help, please ...
Re: problem of message do you want to save changes ... when I press on button that make execute query [message #678882 is a reply to message #678880] Mon, 20 January 2020 00:19 Go to previous messageGo to next message
Michel Cadot
Messages: 66934
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Please read How to use [code] tags and make your code easier to read.
Indent the code, make sure that lines of code do not exceed 80 characters.

Re: problem of message do you want to save changes ... when I press on button that make execute query [message #678887 is a reply to message #678882] Mon, 20 January 2020 05:05 Go to previous message
cookiemonster
Messages: 13864
Registered: September 2008
Location: Rainy Manchester
Senior Member
This is a form question, not a reports question. I've moved it to the appropriate sub-forum.

You really need to format your code, that's very hard to follow.

Execute_query doesn't appear anywhere in this code.

This does however:
V_NSAVE:=SHOW_ALERT(V_SAVE);

Which makes me suspect the form is doing exactly what you told it to do.
Previous Topic: pdf file opening
Next Topic: Using custom.pll
Goto Forum:
  


Current Time: Sat Apr 04 22:47:45 CDT 2020