Home » Developer & Programmer » Forms » How to know if my LOV is empty or not??? (Oracle 9i)
How to know if my LOV is empty or not??? [message #319405] Sat, 10 May 2008 13:51 Go to next message
urnikhil
Messages: 42
Registered: March 2008
Member
Hi Friends,

This is my first post to this forum. Anyways It would be of great help if anyone can let me know " How to know If my LOV contains values in it or not before displaying it" ???

Thanks,

Nik.
Re: How to know if my LOV is empty or not??? [message #319406 is a reply to message #319405] Sat, 10 May 2008 14:23 Go to previous messageGo to next message
Littlefoot
Messages: 20891
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
What would you do with such an information?

User will see if LoV is empty when he/she opens it, so - why bother at all?
However, as you know a query used in LoV's Record Group, you might check what COUNT(*) says. If you want to do it "all the time", user timer. Or, use a button so that user might click on it and get the information whether LoV is empty or not (but that's stupid because it is the same as normally opening the LoV).
Re: How to know if my LOV is empty or not??? [message #319411 is a reply to message #319406] Sat, 10 May 2008 14:44 Go to previous messageGo to next message
urnikhil
Messages: 42
Registered: March 2008
Member
Hi,

If the LOV is empty.. It's throwing me an FRM error saying "List of Values do not contain any entries"... I don't want to handle this using ON-ERROR trigger.

At the same time I don't want to check for the COUNT(*) each time I need to display the LOV, the reason being that the LOV is so often called by the user.

I want to know if there is any record group (or) LOV property which will let me know that the LOV is empty or not... Based on this I want to shoot an alert message if LOV is empty when the user clicks on the text item for which the LOV is attached instead of a FRM error which the user is not familiar with...

Nik.

Re: How to know if my LOV is empty or not??? [message #319464 is a reply to message #319411] Sun, 11 May 2008 12:39 Go to previous messageGo to next message
urnikhil
Messages: 42
Registered: March 2008
Member
GET_GROUP_ROW_COUNT returns me the number of rows in the record group of the corresponding LOV. I guess this will help me. Anyways thanx guyz..

- Nik.
Re: How to know if my LOV is empty or not??? [message #319474 is a reply to message #319464] Sun, 11 May 2008 15:38 Go to previous message
Littlefoot
Messages: 20891
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Oh, there IS a built-in? I didn't know that. Thank you for sharing!
Previous Topic: HOW TO INSTALL FORM & REPORT BUILDER 6i
Next Topic: calculate
Goto Forum:
  


Current Time: Sat Dec 03 18:24:45 CST 2016

Total time taken to generate the page: 0.12959 seconds