| how to use LOV (split calling report from oracel form) [message #406836] |
Sat, 06 June 2009 04:53  |
csgirl
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 :
declare
room_no booked.RNO%type;
from_d booked.from_date%type;
to_d booked.to_date%type;
begin
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 --
end;
|
|
|
|
| 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  |
 |
vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH
|
Senior Member |
|
|
Your select looks strange.| Quote: | 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).
By
Vamsi
[Updated on: Sat, 06 June 2009 05:52] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
