Home » Developer & Programmer » Forms » form status change
form status change [message #207454] Tue, 05 December 2006 11:23 Go to next message
srinivas.k2005
Messages: 404
Registered: August 2006
Senior Member
Hi,

I am working on tab canvas, i move to 3rd tab canvas i have some feilds in 3rd canvas,i press tab button to check navigation.After that if i click save ,Its poping up a message 'do you want to save the changes',

But i have not changed any item in the canvas,just i pressed tab button and when i give message(:system.form_status),it is showing changed even though i have not changed anything on the canvas.

please let me know what code i should write to save without poping the message ,when i have not changed any item.

presently my code is:

if :system.form_status = 'CHANGED' then
---i have written an alert
end if;

Thanks,
Srinivas
Re: form status change [message #207505 is a reply to message #207454] Tue, 05 December 2006 17:15 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
The problem is not "what code i should write to save without poping the message" but "where have I populated a database field inappropriately".

Look at ALL your triggers, but especially the Post-Query, Pre-Block, and Pre-Text-Item triggers and make sure that you are not RE-populating an already populated database field.

David
Re: form status change [message #207703 is a reply to message #207454] Wed, 06 December 2006 12:34 Go to previous messageGo to next message
srinivas.k2005
Messages: 404
Registered: August 2006
Senior Member
Thanks for your reply i will check it.
Re: form status change [message #274684 is a reply to message #207505] Tue, 16 October 2007 16:25 Go to previous messageGo to next message
deahayes3
Messages: 203
Registered: May 2006
Senior Member

Im having a similar problem to Srinivas, except that I am changing a value , is there a way to change the form status back to query even if I changed a value programmaticaly so that my validation triggers wont fire.
my problem is that i am changing between radio buttons programmatically which is causing the form status to change, is there a way like in "set_radio_button_property" that I can change radio buttons without changing the form status??

[Updated on: Tue, 16 October 2007 16:38]

Report message to a moderator

Re: form status change [message #274692 is a reply to message #274684] Tue, 16 October 2007 19:06 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Why not test the current value and if it is the same as the value you are going to use then don't update the field?

David
Re: form status change [message #274700 is a reply to message #274692] Tue, 16 October 2007 20:45 Go to previous message
deahayes3
Messages: 203
Registered: May 2006
Senior Member

it will always change/update because i am changing the default radio button to another radio button value
Previous Topic: Problem using Win_Api_Shell package.
Next Topic: How to display DD-MON-YYY HH24:MI:SS in form field time has to gets refreshed every min and second
Goto Forum:
  


Current Time: Sun Feb 02 21:59:38 CST 2025