OraFAQ Forum: Forms » 'Do you want to save change you have made'

Home » Developer & Programmer » Forms » 'Do you want to save change you have made' (Form6i)

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

'Do you want to save change you have made' [message #329289]

Tue, 24 June 2008 23:09

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

Report message to a moderator

Re: 'Do you want to save change you have made' [message #329301 is a reply to message #329289]

Tue, 24 June 2008 23:59

mm_kanish05
Messages: 493
Registered: January 2007
Location: Chennai

Senior Member

How to exit_form;

send your code, or else user this code

 exit_form(no_validate);

kanish

Report message to a moderator

Re: 'Do you want to save change you have made' [message #329303 is a reply to message #329301]

Wed, 25 June 2008 00:15

Frank
Messages: 7901
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?

Report message to a moderator

Re: 'Do you want to save change you have made' [message #329326 is a reply to message #329289]

Wed, 25 June 2008 01:56

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

Report message to a moderator

Re: 'Do you want to save change you have made' [message #329327 is a reply to message #329326]

Wed, 25 June 2008 02:10

Frank
Messages: 7901
Registered: March 2000

Senior Member

You ARE doing modifications!
Remove all form-triggers you have and try again.

Report message to a moderator

Re: 'Do you want to save change you have made' [message #329365 is a reply to message #329289]

Wed, 25 June 2008 03:55

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

Report message to a moderator

Re: 'Do you want to save change you have made' [message #329465 is a reply to message #329289]

Wed, 25 June 2008 08:48

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

Report message to a moderator

Re: 'Do you want to save change you have made' [message #329567 is a reply to message #329289]

Wed, 25 June 2008 21:25

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

Report message to a moderator

Re: 'Do you want to save change you have made' [message #346770 is a reply to message #329567]

Tue, 09 September 2008 12:23

michaelv
Messages: 20
Registered: November 2006
Location: rockville, MD

Junior Member

Hi
Which trigger did you put this command?

thanks.

Report message to a moderator

Re: 'Do you want to save change you have made' [message #346910 is a reply to message #329567]

Wed, 10 September 2008 01:24

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Using 'FORMS_DDL('I am a thicky');' will work just as well. Use 'standard.commit'.

David

Report message to a moderator

Re: 'Do you want to save change you have made' [message #346981 is a reply to message #329289]

Wed, 10 September 2008 05:29

sasipalarivattom
Messages: 121
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...

Report message to a moderator

Re: 'Do you want to save change you have made' [message #347003 is a reply to message #329289]

Wed, 10 September 2008 07:05

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

Report message to a moderator

Re: 'Do you want to save change you have made' [message #533555 is a reply to message #329289]

Wed, 30 November 2011 09:26

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.

Report message to a moderator

Previous Topic:	Key-next-item
Next Topic:	Copy value from

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Feb 03 07:01:33 CST 2025