| How to know if my LOV is empty or not??? [message #319405] |
Sat, 10 May 2008 13:51  |
urnikhil
Messages: 23
Registered: March 2008 |
Junior 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  |
Littlefoot
Messages: 6174
Registered: June 2005
Location: Croatia, Europe |
Senior Member |
|
|
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 |
urnikhil
Messages: 23
Registered: March 2008 |
Junior 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 |
urnikhil
Messages: 23
Registered: March 2008 |
Junior 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 |
Littlefoot
Messages: 6174
Registered: June 2005
Location: Croatia, Europe |
Senior Member |
|
|
|
Oh, there IS a built-in? I didn't know that. Thank you for sharing!
|
|
|
]
Members
Search
Help
Register
Login
Home
