OraFAQ Forum: Forms » clear form after commit

Home » Developer & Programmer » Forms » clear form after commit

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

clear form after commit [message #242752]

Tue, 05 June 2007 00:15

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,

Report message to a moderator

Re: clear form after commit [message #242759 is a reply to message #242752]

Tue, 05 June 2007 00:53

Frank Naude
Messages: 4595
Registered: April 1998

Senior Member

Try using built-in's like CLEAR_FORM and CLEAR_BLOCK.

Report message to a moderator

Re: clear form after commit [message #242793 is a reply to message #242759]

Tue, 05 June 2007 02:18

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...

Report message to a moderator

Re: clear form after commit [message #242809 is a reply to message #242793]

Tue, 05 June 2007 03:44

shyam.2384
Messages: 16
Registered: March 2007
Location: BHILAI

Junior Member

Try this

clear_form(no_validate,full_rollback);

after commit_form

Report message to a moderator

Re: clear form after commit [message #242863 is a reply to message #242809]

Tue, 05 June 2007 05:51

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,

Report message to a moderator

Re: clear form after commit [message #242883 is a reply to message #242752]

Tue, 05 June 2007 07:29

Littlefoot
Messages: 21823
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?

Report message to a moderator

Re: clear form after commit [message #242898 is a reply to message #242863]

Tue, 05 June 2007 08:04

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

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...

Report message to a moderator

Previous Topic:	Can not update the record (topic split)
Next Topic:	Global variables in Forms

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Mar 10 09:01:26 CDT 2025