OraFAQ Forum: Forms » How to populate values in a list box?

Home » Developer & Programmer » Forms » How to populate values in a list box? (Oracle 9i, d2k6i, Windows XP)

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

How to populate values in a list box? [message #300469]

Fri, 15 February 2008 09:23

hushab2001
Messages: 9
Registered: February 2008

Junior Member

thank you very much for the explanation. i really appreciate it.
if u have knowledge about d2k 6i can u please tell me as to how can i populate values in a list box from the emp table.
i want all the employee nos from the emp table into the list box which i have placed on the form.
any help will be really appreciated.
thank u.

[Topic SPLIT by LF as it has nothing to do with resolving service name problem]

[Updated on: Fri, 15 February 2008 15:11] by Moderator

Report message to a moderator

Re: How to populate values in a list box? [message #300554 is a reply to message #300469]

Fri, 15 February 2008 23:22

dbhossain
Messages: 155
Registered: August 2007
Location: Dhaka

Senior Member

try this:

-------------------------------------
DECLARE
EMPNO_RG RECORDGROUP;
STATUS NUMBER;
BEGIN
EMPNO_RG:=CREATE_GROUP_FROM_QUERY
('EMPNO_RG','SELECT EMPNO,EMPNO FROM
EMP');

IF NOT ID_NULL(EMPNO_RG) THEN
STATUS:=POPULATE_GROUP(EMPNO_RG);
POPULATE_LIST('LISTBOX1',EMPNO_RG);
END IF;
END;

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

Report message to a moderator

Re: How to populate values in a list box? [message #300716 is a reply to message #300469]

Sun, 17 February 2008 22:52

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Have you tried using a Record Group and an LOV?

David

Report message to a moderator

Re: How to populate values in a list box? [message #301266 is a reply to message #300716]

Tue, 19 February 2008 22:18

hushab2001
Messages: 9
Registered: February 2008

Junior Member

i m trying to insert records in a base table,on the when_button_pressed trigger manually.but it doesnt insert records.
when i close the window it asks"do u want to save changes made"and wheni click yes then it inserts records in table.
i want the records to be inserted and transaction committed as soon as i press thebutton
please help me!!

Report message to a moderator