OraFAQ Forum: Forms » How can I display dynamic LOV ?

Home » Developer & Programmer » Forms » How can I display dynamic LOV ?

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

How can I display dynamic LOV ? [message #262979]

Tue, 28 August 2007 12:48

aftab248
Messages: 14
Registered: August 2007
Location: Bangladesh

Junior Member

Hello Everyone
I want to create dynamic Lov. How can I create it? For practice I create a LOV at design time RECORD_GROUP_QUERY value: SELECT * FROM
EMP. THEN I write some code in WHEN-BUTTON-PRESSED Trigger to replace RECORD_GROUP_QUERY at run time. Code is:
........
v_rg_id:=CREATE_GROUP_FROM_QUERY('TEST','SELECT * FROM DEPT');
........
After this I found a error at run time which is
FRM-41826: Cannot replace group; columns don't match LOV.

I need it very much.If any solution,please tell me with example.

Best Wishes
Aftab

Report message to a moderator

Re: How can I display dynamic LOV ? [message #263009 is a reply to message #262979]

Tue, 28 August 2007 14:26

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Quote:

Cannot replace group; columns don't match LOV.

Those two queries do not return the same column set. It *might* work if the first query was something like

SELECT empno, ename, job
FROM emp

and another one

SELECT deptno ename, dname ename, loc job
FROM dept

Note column aliases I used; I can't test it at the moment, so maybe such a column mapping isn't necessary.

Report message to a moderator

Re: How can I display dynamic LOV ? [message #263053 is a reply to message #262979]

Tue, 28 August 2007 23:16

azamkhan
Messages: 557
Registered: August 2005

Senior Member

In the select query specify the column names and in LOV property also specify the column.

Regards,
Azam Khan

Report message to a moderator

Re: How can I display dynamic LOV ? [message #272373 is a reply to message #262979]

Thu, 04 October 2007 15:33

mailsush
Messages: 4
Registered: July 2005
Location: Bangalore

Junior Member

Hi,

Follow the below steps to create dynamic LOV,

1. Create a Record Group(RG)
2. Create RG SQL Query as
Select 1,2,3,4,5 from dual;

Make sure you set the datatype accordingly w.r.t your col in the dynamic query to be used in the below package.
Here 1,2,3,4,5 represents the number of columns for your query

3. Create an LOV an attach this RG to it
4. Add the below logic to the trigger,
CLick on the field to which LOV is attached. it will show up.

DECLARE
result Number;
rec_id RecordGroup;
rwcnt NUMBER;
p_lovname VARCHAR2(40);
p_rg_name VARCHAR2(40);
lc_query VARCHAR2(1000);

BEGIN
p_lovname := <LOV_name>
p_rg_name := <RG_Name>
lc_query:= 'SELECT
item_name
,desc ,Attr1
,Attr2
,Attr3
from <Your tab name>;

rec_id := find_Group(p_rg_name );
result := POPULATE_GROUP_WITH_QUERY(rec_id, lc_query);
rwcnt := Get_Group_Row_Count(rec_id);
SET_LOV_PROPERTY(p_lovname, GROUP_NAME, rec_id);
END;

This should work for you.

Regards,
Mailsush

Report message to a moderator

Re: How can I display dynamic LOV ? [message #272666 is a reply to message #272373]

Fri, 05 October 2007 22:08

dbhossain
Messages: 155
Registered: August 2007
Location: Dhaka

Senior Member

Helo,

You can follow below way for dynamic LOV creating and populating:

step 1: create a RECORD GROUP First named REC1 as follows:

Click "Record Groups" Node at object Navigator and Click Create and name it as "REC1"
and double Click the REC1 and go to "Record Group Query" type the following Query Command:

SELECT EMPNO,ENAME,
FROM EMP
WHERE DEPTNO=:EMP.DEPTNO order by empno asc

Step: 2 Click LOV node from object navigator and create a LOV Named E_LOV
double click to LOV and go to its "Record Group" Property and select "REC1"

now creat a pushbutton to call the lov and type the following code to call LOV

-----------------
declare
x boolean;

begin
x:=show_lov('E_LOV');
end;

i think it will help you

Best Regards

------------------

Report message to a moderator

Re: How can I display dynamic LOV ? [message #272703 is a reply to message #262979]

Sat, 06 October 2007 06:08

anisam10674
Messages: 18
Registered: March 2007

Junior Member

Maybe creation of a record_group at runtime using create_group_from_query() and then assigned to the LOV using set_lov_property() can solve most of your queries. After that you can manipulate the LOV properties

Report message to a moderator

Re: How can I display dynamic LOV ? [message #571752 is a reply to message #272373]

Thu, 29 November 2012 22:48

tianpan
Messages: 1
Registered: August 2012
Location: China

Junior Member

Mailsush's post is helpful for me.Tks

Report message to a moderator

Previous Topic:	Adding a Save (Update) button
Next Topic:	Logo & Home Page Picture Quality

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 02 23:07:12 CST 2025