Home » Developer & Programmer » Forms » 'Do you want to save change you have made' (Form6i)
'Do you want to save change you have made' [message #329289] Tue, 24 June 2008 23:09 Go to next message
aorlunla
Messages: 20
Registered: March 2008
Junior Member
Hi Everyone,

After I query the record and closing the form the error 'Do you want to save changes you have made' will appear without entering or modifying records in he form. So how can I avoid this message?

Please help me.

Regards,
aorlunla
Re: 'Do you want to save change you have made' [message #329301 is a reply to message #329289] Tue, 24 June 2008 23:59 Go to previous messageGo to next message
mm_kanish05
Messages: 487
Registered: January 2007
Location: Chennai
Senior Member

How to exit_form;

send your code, or else user this code
 exit_form(no_validate);


kanish
Re: 'Do you want to save change you have made' [message #329303 is a reply to message #329301] Wed, 25 June 2008 00:15 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Wrong, because it would also give no warning if I DID make changes!
The error is somewhere in your logic: you do make a change to your record after querying it. Probably some field is updated by a form-trigger?
Re: 'Do you want to save change you have made' [message #329326 is a reply to message #329289] Wed, 25 June 2008 01:56 Go to previous messageGo to next message
aorlunla
Messages: 20
Registered: March 2008
Junior Member
Thanks for the information...

I am closing without doing any modifications/updates
But I am getting this message.
How can I solve this problem?

Please help me.

Regards,
aorlunla

Re: 'Do you want to save change you have made' [message #329327 is a reply to message #329326] Wed, 25 June 2008 02:10 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
You ARE doing modifications!
Remove all form-triggers you have and try again.
Re: 'Do you want to save change you have made' [message #329365 is a reply to message #329289] Wed, 25 June 2008 03:55 Go to previous messageGo to next message
aorlunla
Messages: 20
Registered: March 2008
Junior Member
Thanks for the information...

when update records and then save It always show this message too.

my Trigger for update:
update_ff_check;
show_msg_alert;
clear_block;
FORMS_DDL('commit');
APP_STANDARD.EVENT('KEY-COMMIT');


Regards,
aorlunla

Re: 'Do you want to save change you have made' [message #329465 is a reply to message #329289] Wed, 25 June 2008 08:48 Go to previous messageGo to next message
cjack
Messages: 22
Registered: June 2008
Junior Member
Hi,

Do you do any data fields changes in when-new-item-instance , when-new-record-instance , post-item , when-validate-item or post-query trigger? If do, will request you to save when exiting and querying.

Jack
Re: 'Do you want to save change you have made' [message #329567 is a reply to message #329289] Wed, 25 June 2008 21:25 Go to previous messageGo to next message
aorlunla
Messages: 20
Registered: March 2008
Junior Member
Hi Everyone,

Now I can solve this problem by using FORMS_DDL('commit') just 1 place.
not in both program unit and form trigger.

Thank you so much for every information.



Regards,
aorlunla

Re: 'Do you want to save change you have made' [message #346770 is a reply to message #329567] Tue, 09 September 2008 12:23 Go to previous messageGo to next message
michaelv
Messages: 20
Registered: November 2006
Location: rockville, MD
Junior Member
Hi
Which trigger did you put this command?

thanks.
Re: 'Do you want to save change you have made' [message #346910 is a reply to message #329567] Wed, 10 September 2008 01:24 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Using 'FORMS_DDL('I am a thicky');' will work just as well. Use 'standard.commit'.

David
Re: 'Do you want to save change you have made' [message #346981 is a reply to message #329289] Wed, 10 September 2008 05:29 Go to previous messageGo to next message
sasipalarivattom
Messages: 118
Registered: June 2007
Location: Cochin ( INDIA )
Senior Member

dear
aorlunla ,

Please make sure that in the post-query trigger, you are not modifying any database item.

set_record_property(:system.trigger_record,:system.trigger_block,status,query_status);


Write this code in the post query after all your codes.

Hopes this will solve your problem.

Regards,
Sasi...

Re: 'Do you want to save change you have made' [message #347003 is a reply to message #329289] Wed, 10 September 2008 07:05 Go to previous messageGo to next message
cookiemonster
Messages: 12403
Registered: September 2008
Location: Rainy Manchester
Senior Member
While setting the block status to query at the end of the post-query trigger usually fixes this problem I have found cases where it doesn't.
This is usually when you've got non-database text items (not display items) with when-validate-item triggers attached being populated by the post-query trigger.
The only foolproof method I've ever found to stop the post-query trigger changing the record status is to do:
set_item_property(<block_name.item_name>, item_is_valid, property_true);

for every item being set by the post-query trigger.
Re: 'Do you want to save change you have made' [message #533555 is a reply to message #329289] Wed, 30 November 2011 09:26 Go to previous message
mkhalil
Messages: 108
Registered: July 2006
Location: NWFP Peshawar Pakistan
Senior Member
dear sasipalarivattom,
Thanks a lot for your so kind. This statement has also solved my problem i was facing same problem.
Previous Topic: Key-next-item
Next Topic: Copy value from
Goto Forum:
  


Current Time: Fri Dec 02 18:46:36 CST 2016

Total time taken to generate the page: 0.33864 seconds