OraFAQ Forum: Forms » Clearing the data when i change value in LOV

Home » Developer & Programmer » Forms » Clearing the data when i change value in LOV (Forms 6i)

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

Clearing the data when i change value in LOV [message #334035]

Tue, 15 July 2008 04:39

astaputra
Messages: 11
Registered: July 2008

Junior Member

Hello,
I want to clear the block when i select value in LOV. My Scenario is:
I have text box for supplier in Master block. The data is populated through LOV. If i change the supplier, i need to clear the data in Detailed block.
I am not able to use the below code as it is not permitted in WHEN-VALIDATE-ITEM

go_block(REQ_DTLS');
Clear_Block(NO_VALIDATE);

Can any one guide me how to solve this problem.

Regards,
Akash

[Updated on: Tue, 15 July 2008 20:27]

Report message to a moderator

Re: Clearing the data when i change value in LOV [message #334251 is a reply to message #334035]

Wed, 16 July 2008 00:02

ora_baby
Messages: 89
Registered: May 2008

Member

try to use trigger WHEN-NEW-ITEM-INSTANCE on supplier field

Report message to a moderator

Re: Clearing the data when i change value in LOV [message #334256 is a reply to message #334251]

Wed, 16 July 2008 00:24

astaputra
Messages: 11
Registered: July 2008

Junior Member

Hi,
Problem was resolved. I tried that one also, it not working. After selecting Supplier, i need to click on button to populate the records. At that point i am checking whether Orders which are there in detail block are belongs to the same supplier. if different means i am clearing the block, if not i am not. Thats the solution for my problem.

Any how thanks for your response.

Regards,
Akash

Report message to a moderator

Re: Clearing the data when i change value in LOV [message #672506 is a reply to message #334256]

Wed, 17 October 2018 01:00

firozali89
Messages: 1
Registered: November 2017

Junior Member

can you please send the code which you solved your issue

Report message to a moderator

Re: Clearing the data when i change value in LOV [message #672507 is a reply to message #672506]

Wed, 17 October 2018 01:40

Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

If you click on his name you will see:
Last Message: Thu, 31 July 2008 11:31
Last Visited: Sun, 05 July 2009 13:00
So I doubt you will have any answer to your request.

Report message to a moderator

Previous Topic:	insert animated gif in forms
Next Topic:	oracle form

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 02 00:31:26 CST 2025