Home » Developer & Programmer » Forms » How to populate values in a list box? (Oracle 9i, d2k6i, Windows XP)
How to populate values in a list box? [message #300469] Fri, 15 February 2008 09:23 Go to next message
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 Go to previous messageGo to next message
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;


-------------------------------------
Re: How to populate values in a list box? [message #300716 is a reply to message #300469] Sun, 17 February 2008 22:52 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Have you tried using a Record Group and an LOV?

David
Re: How to populate values in a list box? [message #301266 is a reply to message #300716] Tue, 19 February 2008 22:18 Go to previous messageGo to next message
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!!
Re: How to populate values in a list box? [message #301290 is a reply to message #301266] Wed, 20 February 2008 00:08 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Why? What's wrong with the default dehaviour of the 'smartbar'?

Please post your code.

David
Re: How to populate values in a list box? [message #301414 is a reply to message #300554] Wed, 20 February 2008 09:16 Go to previous message
dillango
Messages: 145
Registered: January 2008
Senior Member
Hi,

Where do you execute this block? I mean which trigger?

Ilango
Previous Topic: Example how to get data from excel file
Next Topic: Error while running OC4J instance
Goto Forum:
  


Current Time: Fri Dec 02 22:52:07 CST 2016

Total time taken to generate the page: 0.08748 seconds