Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 3412
  • Last Modified:

Creating Custom LOV (List of Values) programmatically on Form

Hi All,

Please let me know Is there any way to create Custom LOV Programmatically.
I can do it using LoV Wizard but requirement  is like that LOV should be created Programmatically.

I know "How to create record groups Programmatically" but want to attach this record group to A LOV created Programmatically.

Please let me know if there is any workaround for this. I would really appreciate your quick response.

Thanks!!!
Kalyan
0
Kalyan_Thalakoti
Asked:
Kalyan_Thalakoti
1 Solution
 
Naveen KumarProduction Manager / Application Support ManagerCommented:
you can create a lov programmatically and attach a record group to this.

you can use SET_LOV_PROPERTY(..) to attach a record group to the lov.

Thanks

0
 
Naveen KumarProduction Manager / Application Support ManagerCommented:
just look into create_group_from_query(...) in the developer 2000 help which has an example.

Thanks
0
 
Kalyan_ThalakotiAuthor Commented:
Let me know how to create Love Programmatically.
Can you give me standard procedures used to create LOV programmatically?

Thanks!!
0
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
Kalyan_ThalakotiAuthor Commented:
I suppose create_group_from_query(..) is used to populate record group from Query.....I did use this procedure before.

Let me know Is there anything like Create_Lov procedure ?
0
 
Naveen KumarProduction Manager / Application Support ManagerCommented:
There is nothing like that as far as i know.

Static lov means the list is predefined ( at the time of creation ).

Dynamic lov means it gets the list ( from a select query at the run time ). But as you have told, we can use the same lov to show different lists ( by using 2 records groups and attaching them to the lov during runtime ).

Thanks
0
 
Naveen KumarProduction Manager / Application Support ManagerCommented:
http://www.experts-exchange.com/Databases/Q_20597191.html

This is something reated to lov but only deals with showing dynamic values which is again using create_group_from_query(..) only.

Thanks
0
 
Mark GeerlingsDatabase AdministratorCommented:
Are you asking for the ability for a user at runtime in Oracle Forms to be able to dynamically create an LOV?  I don't think that Oracle Forms gives us a way to do that.  As far as I know, the LOVs must be created at design time.  At runtime you can change the record group dynamically, but the new record group will need to have the same number of columns with the same datatypes as the original.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now