OraFAQ Forum: Forms » Execute_query save changes message

Home » Developer & Programmer » Forms » Execute_query save changes message

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

Execute_query save changes message [message #211145]

Tue, 26 December 2006 14:08

smulukutla
Messages: 45
Registered: May 2006

Member

We have a form with master-detail and when_tab_changed trigger.
This trigger has execute_query built in, the problem is when we change the tab page, it is asking 'Do you want to save the changes you have made?', Is there a way to stop this message unless a record is changed or added, etc.

Report message to a moderator

Re: Execute_query save changes message [message #211150 is a reply to message #211145]

Tue, 26 December 2006 18:35

wency
Messages: 450
Registered: April 2006
Location: Philippines

Senior Member

I suspect you have modified some of the field on post-query or any other trigger. In this case the status = 'CHANGED'. You can commit to stop this, or revert your status to 'NEW'(not a nice idea), or set those items(modified by trigger) to non-base then manually insert or update them.

Report message to a moderator

Re: Execute_query save changes message [message #211309 is a reply to message #211145]

Wed, 27 December 2006 22:10

myclassic
Messages: 136
Registered: December 2006
Location: Pakistan

Senior Member

system.message_level :=25;

it will solve ur problem. other wise commit ;

Report message to a moderator

Re: Execute_query save changes message [message #211438 is a reply to message #211150]

Thu, 28 December 2006 12:23

smulukutla
Messages: 45
Registered: May 2006

Member

Thanks for your reply, I have already wrote in the pre-form trigger:
:SYSTEM.MESSAGE_LEVEL := '25';
COMMIT;
When I run the form, it is giving me the error:
FRM-40737: Illegal restricted procedure COMMIT in PRE-FORM trigger.

Please suggest me what I need to do?

Report message to a moderator