OraFAQ Forum: Forms » clearing text item

Home » Developer & Programmer » Forms » clearing text item (Oracle forms 10g, windows 7)

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

clearing text item [message #610899]

Tue, 25 March 2014 12:39

thelearner
Messages: 133
Registered: April 2013
Location: INDIA

Senior Member

Hi I have 3 text items with lovs.

Text Items A,B,C.
My scenarios are
1) if A is null then B and C should be disable.
2) If I enter value in text item A then B should be enable.
3) If I enter value in text item B then C should be enable.
4) if I clear text item A then B and C values should be clear (both B and C values clear at a time)and disabled.

Please give me suggestions how to do this.

Thanks & Regards,
The Learner.

Report message to a moderator

Re: clearing text item [message #610906 is a reply to message #610899]

Tue, 25 March 2014 13:51

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

Senior Member
Account Moderator

You've said it all - now just put those sentences into Oracle code. You'll need WHEN-VALIDATE-ITEM triggers, basic PL/SQL skills, SET_ITEM_PROPERTY built-in and that's more or less all.

Report message to a moderator

Re: clearing text item [message #610986 is a reply to message #610906]

Wed, 26 March 2014 09:12

thelearner
Messages: 133
Registered: April 2013
Location: INDIA

Senior Member

I have got 1 to 3 but in 4 am unable to clear B and C at a time.

Report message to a moderator

Re: clearing text item [message #610987 is a reply to message #610986]

Wed, 26 March 2014 09:17

cookiemonster
Messages: 13920
Registered: September 2008
Location: Rainy Manchester

Senior Member

set them to null.

Report message to a moderator

Re: clearing text item [message #610988 is a reply to message #610987]

Wed, 26 March 2014 09:30

thelearner
Messages: 133
Registered: April 2013
Location: INDIA

Senior Member

Thank you Littlefoot and cookiemonster.
My problem solved.

I have one doubt I opened the form then I try to close the form it is showing "Close the form?".

Is it a error?

Report message to a moderator

Previous Topic:	Error ora-305500 when getting result in excell from oracle10g forms using application server
Next Topic:	error files compare

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 15:20:18 CDT 2024