OraFAQ Forum: Forms » dynamic record group for LOV (merged)

Home » Developer & Programmer » Forms » dynamic record group for LOV (merged) (oracle forms developer 10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

dynamic record group for LOV (merged) [message #495761]

Tue, 22 February 2011 03:41

coder
Messages: 13
Registered: February 2011
Location: United States

Junior Member

hi,

I want to create a Dynamic record group and associate it to a LOV.
for example: I want that for a set of people A, i want to fire the query in lov:
select * from emp where (condition 1)
and for another set of people B, I want to fire
select * from emp where (condition 2)...

How could I achieve it?

Report message to a moderator

Re: dynamic record group for LOV [message #495774 is a reply to message #495761]

Tue, 22 February 2011 04:06

cookiemonster
Messages: 13938
Registered: September 2008
Location: Rainy Manchester

Senior Member

Use two seperate LOV's. swap them with set_item_property based on the user.

Report message to a moderator

Re: dynamic record group for LOV [message #495796 is a reply to message #495774]

Tue, 22 February 2011 05:44

coder
Messages: 13
Registered: February 2011
Location: United States

Junior Member

thanks its working fine.

By the way i wanted to do it by creating one LOV and passing record group dynamically??? Is it the limitation or it can't go that way???

Report message to a moderator

Re: dynamic record group for LOV [message #495799 is a reply to message #495796]

Tue, 22 February 2011 05:59

cookiemonster
Messages: 13938
Registered: September 2008
Location: Rainy Manchester

Senior Member

Form builder help will tell you. Open up the property pallete of an LOV. Click on the record group property and press F1.
You can use that to check if any property can be changed.
Oracle form builder help is incredibly detailed and has examples for most things, learn to make use of it.

Report message to a moderator

Re: dynamic record group for LOV [message #495875 is a reply to message #495799]

Tue, 22 February 2011 23:47

coder
Messages: 13
Registered: February 2011
Location: United States

Junior Member

Ok thanks

Report message to a moderator

Previous Topic:	SYNCHRONIZE related in forms
Next Topic:	DYNAMIC MENUS BASED ON ROLE_ID & corresponding MENUS information stored in DB (merged 6)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 01:45:40 CDT 2024