Home » Developer & Programmer » Forms » clear form after commit
clear form after commit [message #242752] Tue, 05 June 2007 00:15 Go to next message
mestoganesh
Messages: 16
Registered: May 2007
Location: Chennai
Junior Member
hello experts,
I am using forms9i. i used master detail in one form. I have to clear the form(detail as well as master form)after save (commit),just like reload or refresh form. please give your valuable points for my project.
thanks in advance,
Re: clear form after commit [message #242759 is a reply to message #242752] Tue, 05 June 2007 00:53 Go to previous messageGo to next message
Frank Naude
Messages: 4502
Registered: April 1998
Senior Member
Try using built-in's like CLEAR_FORM and CLEAR_BLOCK.
Re: clear form after commit [message #242793 is a reply to message #242759] Tue, 05 June 2007 02:18 Go to previous messageGo to next message
mestoganesh
Messages: 16
Registered: May 2007
Location: Chennai
Junior Member
thanks your reply sir,

please let me know in which trigger i write these function...

Re: clear form after commit [message #242809 is a reply to message #242793] Tue, 05 June 2007 03:44 Go to previous messageGo to next message
shyam.2384
Messages: 16
Registered: March 2007
Location: BHILAI
Junior Member
Try this


clear_form(no_validate,full_rollback);


after commit_form
Re: clear form after commit [message #242863 is a reply to message #242809] Tue, 05 June 2007 05:51 Go to previous messageGo to next message
mestoganesh
Messages: 16
Registered: May 2007
Location: Chennai
Junior Member
hello shyam,

i under stand the clear_form function, but i dont know in which trigger i called clear_form function. please share your valuable idea..

Thanks,
Re: clear form after commit [message #242883 is a reply to message #242752] Tue, 05 June 2007 07:29 Go to previous messageGo to next message
Littlefoot
Messages: 20895
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
mestoganesh
I have to clear the form after save (commit)
So what do YOU think, which trigger(s) will fire after you commit data?
Re: clear form after commit [message #242898 is a reply to message #242863] Tue, 05 June 2007 08:04 Go to previous messageGo to next message
shyam.2384
Messages: 16
Registered: March 2007
Location: BHILAI
Junior Member
mestoganesh wrote on Tue, 05 June 2007 05:51
hello shyam,

i under stand the clear_form function, but i dont know in which trigger i called clear_form function. please share your valuable idea..

Thanks,


I have created a button named save in which i wrote following coding

SET_ALERT_PROPERTY(ALT_ID,ALERT_MESSAGE_TEXT,'Sure u want to save !');
VAR := SHOW_ALERT(ALT_ID);
IF VAR = ALERT_BUTTON1 THEN

COMMIT_FORM;

if form_success then

GO_ITEM('TOOLBAR.BTN_ADD');
clear_form(no_validate,full_rollback); EXECUTE_TRIGGER('WHEN-NEW-FORM-INSTANCE');
else
Set_Alert_Property('alert_ok',Alert_Message_Text,'RECORD CANNOT BE SAVED !');
VAR := show_alert('alt_ok');
GO_ITEM('TOOLBAR.BTN_EXT');
raise form_trigger_failure;
End if;




I think this will help u....

[Updated on: Tue, 05 June 2007 08:05]

Report message to a moderator

Re: clear form after commit [message #243205 is a reply to message #242898] Wed, 06 June 2007 08:08 Go to previous message
mestoganesh
Messages: 16
Registered: May 2007
Location: Chennai
Junior Member
Thank you sir, its working i gave that code in the key-commit trigger..

thanks for your timely help...
Previous Topic: Can not update the record (topic split)
Next Topic: Global variables in Forms
Goto Forum:
  


Current Time: Tue Dec 06 00:01:05 CST 2016

Total time taken to generate the page: 0.11540 seconds