| dynamic drop down list..... [message #174567] |
Mon, 29 May 2006 14:27  |
imtiazmasud
Messages: 49
Registered: May 2005
Location: Bangladesh
|
Member |
 
|
|
Friends,
Suppose i have a form and there is a drop down and many other components in the form...in this form,i want that my drop down list elements will not be static but dynamic,i want to show data base elements in this drop down list as i query from the database.........please help me
imtiaz-masud
[Updated on: Mon, 29 May 2006 14:28] Report message to a moderator |
|
|
|
|
|
|
|
| Re: dynamic drop down list..... [message #174964 is a reply to message #174567] |
Wed, 31 May 2006 04:26  |
Rehan Mirza
Messages: 67
Registered: July 2004
Location: Pakistan
|
Member |
|
|
Masud Create this procedure and then call it in when-New-Form-Instance
PROCEDURE Add_List_Dynamic(p_List in Varchar2) IS
CURSOR Dept_Cur IS (SELECT DeptNo,DName FROM Dept);
A NUMBER := 0;
BEGIN
CLEAR_LIST(p_List);
FOR Dp IN Dept_Cur LOOP
A := A + 1;
ADD_LIST_ELEMENT(p_List,A,dp.DName,dp.DeptNo);
END LOOP;
END;
When-New-Form-Instance
Add_List_Dynamic('Emp.DeptNo');
you also use record group and populte list through it
if you need more assistance please remember me
Best regards
R E H A N M I R Z A
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
