OraFAQ Forum: Forms » drop down list problem

Home » Developer & Programmer » Forms » drop down list problem - same problem

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

drop down list problem - same problem [message #174317]

Sat, 27 May 2006 11:00

oracleproblem
Messages: 47
Registered: May 2006
Location: Dhaka

Member

friends,

i have a form.this form contain many text box and top down list.
top down list contain many item but this item is static,

example:topdown list item countryname:usa,india,australia,
suppose a user need a country name but this country name is
not available top down list that time user type this country name
in the top down list but top down list not permit a user type anything.

How can a user type anything top down list.
please help me..........masud

Report message to a moderator

Re: Top down list problem...... [message #174324 is a reply to message #174317]

Sat, 27 May 2006 13:17

Rehan Mirza
Messages: 67
Registered: July 2004
Location: Pakistan

Member

First create this Procedure

PROCEDURE add_list
(p_list in varchar2)
IS
v_list_count number;
BEGIN
if Name_In(p_List) is NOT null then
-- Total Number of List Element
v_list_count := get_list_element_count(p_list);

-- Check Validity
for v_idx in 1 .. v_list_count loop
if upper(get_list_element_value (p_list,v_idx)) =
upper(name_in(p_list)) then
return;
end if;
end loop;
-- add Value to Item
Add_List_Element(p_list,v_List_Count,name_in(p_list),name_in(p_list));
end if;
end;

then create When-Validate-Item trigger on Your List Item
write these code

Add_List(:System.Trigger_Item);

hope it will help full to you

Best regards
R E H A N M I R Z A

Report message to a moderator

drop down list problem [message #174377 is a reply to message #174317]

Mon, 29 May 2006 00:28

iqubalmasud
Messages: 6
Registered: May 2006
Location: BANGLADESH

Junior Member

friends,

i have a form.this form contain many text box and drop down list.
drop down list contain many item but this item is static,

example:dropdown list item countryname:usa,india,australia,
suppose a user need a country name but this country name is
not available top down list that time user type this country name
in the drop down list but drop down list not permit a user type anything.

How can a user type anything drop down list.
please help me..........masud

Report message to a moderator

Re: Top down list problem...... [message #174380 is a reply to message #174324]

Mon, 29 May 2006 00:38

oracleproblem
Messages: 47
Registered: May 2006
Location: Dhaka

Member

sir,
you give me a solution but it will not work but i dont not
why,drop down list no change user could not write any thing
drop down list he select static value
please help me

R E H A N M I R Z A
i compiled your procedure but no change drop down list

Report message to a moderator

Re: Top down list problem...... [message #174461 is a reply to message #174317]

Mon, 29 May 2006 05:13

Rehan Mirza
Messages: 67
Registered: July 2004
Location: Pakistan

Member

Hello you set List Item property "List Style" to "Combo Box"

Best regards
R E H A N M I R Z A

Report message to a moderator

Re: drop down list problem [message #174482 is a reply to message #174377]

Mon, 29 May 2006 06:30

sanka_yanka
Messages: 184
Registered: October 2005
Location: Kolkata

Senior Member

Hi,
Use the Combo Box option of the Property of List Style.
It is a select list as well as User can enter through it.

http://us.f13.yahoofs.com/bc/4407bd0em6f5e8ae4/bc/Sanka/image/list.bmp?bfv5teEBSLMNmTEl

Report message to a moderator

Previous Topic:	Hierarchical Tree
Next Topic:	Radio Buttons..

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Feb 08 11:56:41 CST 2025