OraFAQ Forum: Forms » How to clear field on on-error trigger in oracle forms.

Home » Developer & Programmer » Forms » How to clear field on on-error trigger in oracle forms. (Oracle forms 10g)

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

How to clear field on on-error trigger in oracle forms. [message #611681]

Mon, 07 April 2014 01:54

Rockstar
Messages: 15
Registered: January 2012
Location: Udaipur

Junior Member

need for Help...
i want to clear a text item on on-error trigger...
i am using following code for the same...

if error_code = 40209 and error_type = 'FRM' then
showalert('Please enter valid error value');
clear_item;

its give error as clear_item is not worked on on-error trigger...

Pls help.....

Report message to a moderator

Re: How to clear field on on-error trigger in oracle forms. [message #611682 is a reply to message #611681]

Mon, 07 April 2014 01:59

Littlefoot
Messages: 21809
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

:block.item := null;

Report message to a moderator

Re: How to clear field on on-error trigger in oracle forms. [message #611683 is a reply to message #611682]

Mon, 07 April 2014 02:03

Rockstar
Messages: 15
Registered: January 2012
Location: Udaipur

Junior Member

Dear littlefoot
Thanx for quick reply...
what i want i am explaining more..
i have 20 numeric fields on a block if user enters char value in any of the numeric text_item its give error and i handled the same error on on-error trigger...so
its call on-error trigger when error comes and after showing showalert on on-error trigger i want to clear particular text item value so the problem is item name is not known in advance....i want to clear field at runtime...
i also try with :system.cursor_item and :system.current_item..
but its not working...
help further...

Thanks

[Updated on: Mon, 07 April 2014 02:07]

Report message to a moderator

Re: How to clear field on on-error trigger in oracle forms. [message #611685 is a reply to message #611683]

Mon, 07 April 2014 02:51

Littlefoot
Messages: 21809
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Try this:

  
if error_code = 40209 and error_type = 'FRM' then
   showalert('Please enter valid error value');
   copy(null, :system.trigger_item);            --> this!
end if;

Report message to a moderator

Re: How to clear field on on-error trigger in oracle forms. [message #611687 is a reply to message #611685]

Mon, 07 April 2014 03:25

Rockstar
Messages: 15
Registered: January 2012
Location: Udaipur

Junior Member

its working fine now...
Thank you very much.....

Report message to a moderator

Previous Topic:	webutil_file_transfer.AS_to_Client always retrun false
Next Topic:	Passing DATA_PARAMETER in Oracle Reports 10g from Oracle Forms using RUN_REPORT_OBJECT

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue May 07 06:15:23 CDT 2024