Home » Developer & Programmer » Forms » how to use LOV (split calling report from oracel form)
how to use LOV (split calling report from oracel form) [message #406836] Sat, 06 June 2009 04:53 Go to next message
Messages: 3
Registered: June 2009
Junior Member
i solve this problem ..

but i need another help from you ..

i had wrote a code to return list of values from a table

but i dont know how to return them i a way that the user can choose on of them ..

i read a bout LOV .. but i don't know how to use it !!

this is my code :

room_no booked.RNO%type;
from_d booked.from_date%type;
to_d booked.to_date%type;


SELECT RNO from room where RNO NOT IN (
select RNO into room_no from booked
where booked.from_date <> :from_date AND booked.to_date <> :to_date;

--- need to put a statment to retreve values in a list to chose one of them --

Re: how to use LOV (split calling report from oracle form) [message #406843 is a reply to message #406836] Sat, 06 June 2009 05:47 Go to previous message
vamsi kasina
Messages: 2108
Registered: October 2003
Location: Hyderabad, India
Senior Member
Your select looks strange.
where booked.from_date <> :from_date AND booked.to_date <> :to_date;
Anyway, you can create an LOV.

You can populate the LOV using clear_list/populate_list and create_group/create_group_with_query/populate_group_with_query.
Search for the built-ins in Google or Forum.

Remember to select two character columns (one for LOV value and the other is description).


[Updated on: Sat, 06 June 2009 05:52]

Report message to a moderator

Previous Topic: When Check Box Changed
Next Topic: Ora-12560 TNS Protocol Adapter Failure
Goto Forum:

Current Time: Wed Jul 26 01:34:23 CDT 2017

Total time taken to generate the page: 0.06344 seconds