Home » Developer & Programmer » Forms » Filter a LOV that has AUTO_REFRESH set to FALSE (Forms 6i, Windows 7)
Filter a LOV that has AUTO_REFRESH set to FALSE [message #683854] Wed, 24 February 2021 15:21
Amine
Messages: 338
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
Previous Topic: Custom Message Popping Multiple times- Form Personalization
Next Topic: Form Error : Can not Read file finance_payroll
Goto Forum:
  


Current Time: Sun Jun 13 15:21:31 CDT 2021