OraFAQ Forum: Forms » Filter a LOV that has AUTO

Home » Developer & Programmer » Forms » Filter a LOV that has AUTO_REFRESH set to FALSE (Forms 6i, Windows 7)

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

Filter a LOV that has AUTO_REFRESH set to FALSE [message #683854]

Wed, 24 February 2021 15:21

Amine
Messages: 376
Registered: March 2010

Senior Member

Hi Gurus,
I have a query that takes a lot of time to execute. I need the rows given to show them through a LOV.

So I did :

Set_Lov_Property('lov_name', AUTO_REFRESH, PROPERTY_FALSE);

For the first time, the LOV takes the time needed to execute. After that, when we re-execute the LOV, it does not take time.

Now, when the LOV is shown, I can filter the rows with %.

Is there a way to filter automatically by passing a string to the LOV, without typing the string manually ?

Thanks

Report message to a moderator

Previous Topic:	Custom Message Popping Multiple times- Form Personalization
Next Topic:	Form Error : Can not Read file finance_payroll

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jan 30 17:29:42 CST 2025