Home » Developer & Programmer » Forms » Execute_query save changes message
Execute_query save changes message [message #211145] Tue, 26 December 2006 14:08 Go to next message
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.
Re: Execute_query save changes message [message #211150 is a reply to message #211145] Tue, 26 December 2006 18:35 Go to previous messageGo to next message
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.
Re: Execute_query save changes message [message #211309 is a reply to message #211145] Wed, 27 December 2006 22:10 Go to previous messageGo to next message
myclassic
Messages: 127
Registered: December 2006
Location: Pakistan
Senior Member
system.message_level :=25;

it will solve ur problem. other wise commit ;
Re: Execute_query save changes message [message #211438 is a reply to message #211150] Thu, 28 December 2006 12:23 Go to previous messageGo to next message
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?
Re: Execute_query save changes message [message #211477 is a reply to message #211145] Thu, 28 December 2006 21:10 Go to previous messageGo to next message
wency
Messages: 450
Registered: April 2006
Location: Philippines
Senior Member

commit on when-tab-changed trigger
Re: Execute_query save changes message [message #211505 is a reply to message #211477] Fri, 29 December 2006 00:57 Go to previous messageGo to next message
Littlefoot
Messages: 20891
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
@smulukutla: Just being curious: what would be the purpose of a COMMIT in the PRE-FORM trigger?
Re: Execute_query save changes message [message #211634 is a reply to message #211145] Sat, 30 December 2006 03:44 Go to previous messageGo to next message
amul
Messages: 252
Registered: April 2001
Location: Chennai
Senior Member
system.record_status=changed
then message('');
else
null;
Re: Execute_query save changes message [message #212226 is a reply to message #211145] Thu, 04 January 2007 05:13 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Have you solved your problem?

David
Previous Topic: need help regarding Menu items populate from table
Next Topic: Poplist
Goto Forum:
  


Current Time: Sun Dec 04 08:41:57 CST 2016

Total time taken to generate the page: 0.27451 seconds