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.

Report message to a moderator

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: 21823
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).

Report message to a moderator

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.

Report message to a moderator

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.

Report message to a moderator

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: 21823
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!

Report message to a moderator

Previous Topic: HOW TO INSTALL FORM & REPORT BUILDER 6i
Next Topic: calculate
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Feb 09 05:53:22 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.