Home » Developer & Programmer » Forms » Clearing the data when i change value in LOV (Forms 6i)
Clearing the data when i change value in LOV [message #334035] Tue, 15 July 2008 04:39 Go to next message
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 Go to previous messageGo to next message
ora_baby
Messages: 89
Registered: May 2008
Member
try to use trigger WHEN-NEW-ITEM-INSTANCE on supplier field
Re: Clearing the data when i change value in LOV [message #334256 is a reply to message #334251] Wed, 16 July 2008 00:24 Go to previous message
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
Previous Topic: How to store Pdf file in oracle ?
Next Topic: if comes after commit
Goto Forum:
  


Current Time: Sat Dec 10 05:18:18 CST 2016

Total time taken to generate the page: 0.08654 seconds