OraFAQ Forum: Forms » defining lov list at runtime

Home » Developer & Programmer » Forms » defining lov list at runtime

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

defining lov list at runtime [message #79388]

Wed, 05 June 2002 17:19

tree
Messages: 3
Registered: June 2002

Junior Member

In oracle forms is there a way define a lov list by the a different item on a block? For example, the user selects an data and then moves to the next item where the lov is. I want to lov to only display items relating on the first data entered. Is there a way to do that and how?

Report message to a moderator

Re: defining lov list at runtime [message #79389 is a reply to message #79388]

Wed, 05 June 2002 20:20

Remash
Messages: 52
Registered: November 2000

Member

Yes you can do this by POPULATE_GROUP_WITH_QUERY

FUNCTION POPULATE_GROUP_WITH_QUERY
(recordgroup_name VARCHAR2,
query VARCHAR2);

Regards

Report message to a moderator

Re: defining lov list at runtime [message #79397 is a reply to message #79388]

Thu, 06 June 2002 04:01

tree
Messages: 3
Registered: June 2002

Junior Member

How would I use that to call my LOV? and do I put that on the trigger that calls my LOV?

Report message to a moderator

Re: defining lov list at runtime [message #79419 is a reply to message #79397]

Fri, 07 June 2002 22:18

Remash
Messages: 52
Registered: November 2000

Member

Hi Tree

Use SHOW_LOV('lov name') to show the LOV. Put this under a trigger for example when-botton-pressed or on-help (by pressing F1 key).

Regards

Report message to a moderator

Previous Topic:	disabling the data block items....
Next Topic:	FRM-40737 Restricted Builtin

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 05:39:03 CDT 2024