OraFAQ Forum: Forms » problem of message do you want to save changes ... when I press on button that make execute query

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)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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

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 ...

Report message to a moderator

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

Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...

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.

Report message to a moderator

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

cookiemonster
Messages: 13963
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.

Report message to a moderator

Previous Topic:	pdf file opening
Next Topic:	Using custom.pll

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 02 00:30:25 CST 2025